Backing up SQLServer database in MySQL

Question

I want to take the SQL Server database and convert it to a format that will be easily imported into MySQL.

The plan is that I run this process once a month, back up the SQLServer database to a specific location, and then another process selects it and imports it into MySQL.

I can do a transfer bit, etc. I just don’t know how I would work on the backup process.

Thanks for the help.

Answer 1

One way to get good performance is to create a SQL Server Integration Services (SSIS) package that connects to MySQL, trims the corresponding tables, and uses data streams to copy data from SQL Server tables to MySQL tables.

In fact, there is no general backup format. You could have SQL Server write out a text file with a bunch of INSERT statements. Or you can write plain text CSV files for each table. Text conversions can be a problem. Excel is known for messing around with your data based on what it thinks should be a data type.

Using SSIS is likely to give you the cleanest insertions. He insists on clear data entries, code pages, etc., so you can write your own column transforms to clear up the small differences between SQL Server and MySQL. This may mean significant work, but the fact is that it can be done in a consistent and predictable way. And this should provide decent performance.