Moving a SQL Server database to MySQL without rebuilding it by hand
You have a database in Microsoft SQL Server, and the new project runs on MySQL. Re-creating every table, key and index by hand is slow, and one missed constraint can break the application. MS SQL to MySQL Database Converter is a Windows program that reads your MS SQL database and writes it into MySQL for you, keeping the structure intact.
Quick facts
- Price: $49
- Platform: Windows
- Direction: MS SQL to MySQL
- Connections: local or remote servers
Key features
Convert tables, keys and null constraints together
The converter handles tables, attributes, key constraints and null value constraints. They are mapped to the MySQL format so the database keeps its integrity after the move.
Bring over views, stored procedures and indexes
You can choose to convert views, indexes and stored procedures along with the data. You can also pick schema items manually instead of taking everything.
Move only the table structure when you need it
If you want the layout but not the records, choose the convert table definitions option to transfer structure only.
Choose where the converted data goes
You can save the converted MySQL data to a new location you specify, or overwrite existing records. Single or multiple databases can be converted automatically or manually.
Work with servers on your network or elsewhere
Both the MS SQL and MySQL servers can be reached locally or remotely. The tool supports Unicode character sets, so non-English text should carry across.
Who it's for
It suits administrators and developers who need a one-way migration from SQL Server to MySQL and prefer a wizard-style desktop tool to writing export scripts.
Pros and cons
Pros
- Covers views, stored procedures and indexes, not only tables.
- Lets you select schema items manually.
- Works with local and remote servers.
- Unicode support.
Cons
- Windows only.
- Goes one way only, from MS SQL to MySQL.
- It is a paid program.
FAQs
Can I convert only the table structure?
Yes. Select the convert table definitions option.
Can I convert views and stored procedures?
Yes, the software has an option to convert views, indexes and stored procedures.
Do the servers have to be on my computer?
No. You can connect to MS SQL and MySQL servers locally or remotely.
Can I keep my existing MySQL data safe?
You can save the converted data to a new location rather than overwriting existing records.
System requirements
Runs on Windows. The listing mentions about 128 MB RAM and 20 MB of disk space.