Tag Archives: Migration

Day 17 Backup and Recovery

There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the database You can use following some of the options in the MySQLDump command –all-databases             Dump all tables in all … Continue reading

Posted in Backup and Restore, Disaster Recovery, MySQL, Others | Tagged , , , | Leave a comment

Day 5: Install MySQL and Upgrade

There are multiple ways you can install MySQL, MySQL is compatible for almost all the Operating System. it would be difficult to write a single blog on this, there is a great site (in reference) which provides detail information about … Continue reading

Posted in Installation, Migration, MySQL, Others, What I learned today | Tagged , , | Leave a comment

SQL Server 2005 – Failed Maintenance Job

I Know SQL Server 2005 is no longer in support by Microsoft, but Want to provide a solution for those who have legacy system and come across a issue where maintenance job failed in jobs and on maintenance plan history … Continue reading

Posted in Bug, Error Log, Limitation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

Different ways to move Sql Server file location

Different ways to move Sql Server file location For space issue on drive , performance load balancing or some other reasons, we may have to move physical file of the database to another location. Following are the different ways to … Continue reading

Posted in Backup and Restore, Troubleshooting | Tagged , | Leave a comment

SQL Server Migration Assistant v5.0

I blog about mysql to sql server migration lastly here Today found very good migration tool Free Downloads: 1. SSMA for Access v5.0 2. SSMA for MySQL v5.0 3. SSMA for Oracle v5.0 4. SSMA for Sybase v5.0 Ref: http://blogs.technet.com/b/dataplatforminsider/archive/2011/04/28/sql-server-migration-assistant-v5-0-is-now-available.aspx

Posted in Migration, Tool | Tagged , | Leave a comment