Database Migration and Sync from MS SQL to mySQL
-
I'm looking for a tool that can migrate a MS SQL Server 2014 database to the latest version of MySQL. The migration includes just tables (structure, keys, indexes, etc.) and their data. Then the product needs to sync any data changes made to the SQL Server database with the MySQL database until I'm confident that the changeover of codebases to MySQL are complete...basically inserts, updates, and deletes. There will not be any schema changes allowed during the migration. Downtime of the database for a migration is not really an option. In addition, I'm not too keen on the idea of modifying the data access layers to work with both databases (there's a lot of customization I would have to work with). So it seems to me the best place to do this is at the database level itself. I've been researching tools such as SymmetricDS and ConvertDB. Does anyone have experience with these products that they would like to share? Any other suggestions?
-NP Never underestimate the creativity of the end-user.
-
I'm looking for a tool that can migrate a MS SQL Server 2014 database to the latest version of MySQL. The migration includes just tables (structure, keys, indexes, etc.) and their data. Then the product needs to sync any data changes made to the SQL Server database with the MySQL database until I'm confident that the changeover of codebases to MySQL are complete...basically inserts, updates, and deletes. There will not be any schema changes allowed during the migration. Downtime of the database for a migration is not really an option. In addition, I'm not too keen on the idea of modifying the data access layers to work with both databases (there's a lot of customization I would have to work with). So it seems to me the best place to do this is at the database level itself. I've been researching tools such as SymmetricDS and ConvertDB. Does anyone have experience with these products that they would like to share? Any other suggestions?
-NP Never underestimate the creativity of the end-user.
NickPace wrote:
Any other suggestions?
Yes; change your requirements.
NickPace wrote:
Then the product needs to sync any changes made to the SQL Server database with the MySQL database until I'm confident that the changeover of codebases to MySQL are complete.
That would include changes to structure and relations.
NickPace wrote:
Downtime of the database for a migration is not really an option
Then don't change your database structure while your database is up. Take a look into the sync-framework :thumbsup:
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
I'm looking for a tool that can migrate a MS SQL Server 2014 database to the latest version of MySQL. The migration includes just tables (structure, keys, indexes, etc.) and their data. Then the product needs to sync any data changes made to the SQL Server database with the MySQL database until I'm confident that the changeover of codebases to MySQL are complete...basically inserts, updates, and deletes. There will not be any schema changes allowed during the migration. Downtime of the database for a migration is not really an option. In addition, I'm not too keen on the idea of modifying the data access layers to work with both databases (there's a lot of customization I would have to work with). So it seems to me the best place to do this is at the database level itself. I've been researching tools such as SymmetricDS and ConvertDB. Does anyone have experience with these products that they would like to share? Any other suggestions?
-NP Never underestimate the creativity of the end-user.
NickPace wrote:
until I'm confident that the changeover of codebases to MySQL are complete
I am with the other responder in that the statement of your situation is either unclear or the actual requirements have not been defined. I spun up a number of possibilities but there are just too many to cover. I would suggest that you start by defining exactly and specifically how you will determine that the new solution is working correctly before doing anything else. Additionally unless very strict coding practices were followed the chances that no code changes are needed are rather slim.
-
I'm looking for a tool that can migrate a MS SQL Server 2014 database to the latest version of MySQL. The migration includes just tables (structure, keys, indexes, etc.) and their data. Then the product needs to sync any data changes made to the SQL Server database with the MySQL database until I'm confident that the changeover of codebases to MySQL are complete...basically inserts, updates, and deletes. There will not be any schema changes allowed during the migration. Downtime of the database for a migration is not really an option. In addition, I'm not too keen on the idea of modifying the data access layers to work with both databases (there's a lot of customization I would have to work with). So it seems to me the best place to do this is at the database level itself. I've been researching tools such as SymmetricDS and ConvertDB. Does anyone have experience with these products that they would like to share? Any other suggestions?
-NP Never underestimate the creativity of the end-user.