Moving a SQL Server database into MySQL without writing export scripts
You have data in Microsoft SQL Server and need it in MySQL. Hand-written export scripts and format conversions are slow and easy to get wrong. Viobo MSSQL to MySQL Data Migrator is built for this one job. The vendor says no DBA experience is required.
Quick facts
- Direction: Microsoft SQL databases to a MySQL database server
- Experience needed: no DBA experience
- Related tools from the same vendor: MySQL to MSSQL, Access to MSSQL, MSSQL to Access, Access to MySQL and MySQL to Access
Key features
Define your own conditions for each migration task
You can set operation conditions so a migration task covers only the data you want.
Run several tasks at the same time
The tool can process multiple tasks at once. In the Tasks List you can sort, stop, start, delete and clear waiting tasks.
Drag and drop between database trees
Databases are shown as a tree structure. You drag objects from one tree to another to migrate or back up data.
Who it's for
It suits you if you move data from SQL Server to MySQL and don't want to learn scripting or database administration first. If you also move data in other directions, such as MySQL to SQL Server or Access to MySQL, the vendor makes separate tools for those.
Pros and cons
- Pro: Focused on a single migration path, with a simple drag-and-drop approach.
- Pro: Several tasks can run at once and you can manage them in a task list.
- Con: Each migration direction is a separate product, so other directions mean another tool.
- Con: The vendor's front page gives few technical details.
FAQs
Do I need database administration skills?
The vendor says no DBA experience is required.
Can it move data the other way, from MySQL to SQL Server?
Not with this tool. The vendor sells a separate MySQL to MSSQL Data Migrator for that.
Can I migrate from Access?
Yes, with the vendor's separate Access to MySQL and Access to MSSQL tools.