You have a SQL Server database that needs to live in MySQL, and nobody on your team is a database administrator. Viobo MSSQL to MySQL Data Migrator is built for that job: it moves data from Microsoft SQL databases to a MySQL server, and the vendor says no DBA experience is required.
Quick facts
- Version: 1.8
- Platform: Windows (95/98/ME, NT/2000, XP, Vista, 7)
- Edition: Business edition
- Database support: SQL Server 2000 to 2008, MySQL 3.5x to 5.x
- Connectivity: ODBC or OLEDB providers, no official client software needed
Key features
Drag and drop objects between databases
Databases appear as a tree structure. You drag objects from one tree to another to move data, much like handling files in Windows Explorer.
Run several migrations at once from a task queue
A task queue with multithread management is meant to speed up large migrations. In the task list you can sort, delete, stop, start and clear waiting tasks.
Run your own SQL scripts, stored procedures and functions
If you are comfortable with SQL, you can write SQL scripts, stored procedures and functions to carry out more advanced migrations. You can also set operation conditions so a task only moves the data you want.
Pick the character set and export to files
You choose a standard character set for the data, and the tool handles special table and field names. You can also back up data into data files in a directory you pick, or export to common formats such as text files.
Log and import operations, and larger data fields
Version 1.8 added a log operation and an import operation. It also raised the data size limit from 8K to 512K.
Who it's for
It suits people who need a one-off or occasional move from SQL Server to MySQL without learning a heavy toolchain. It also suits administrators who want to script and queue their own migration tasks.
Pros and cons
Pros
- Simple tree-based, drag-and-drop interface
- Works through ODBC or OLEDB with no vendor client software
- Task queue and multithreading for bigger jobs
- Supports scripts, stored procedures and conditions for advanced users
Cons
- Listed support stops at SQL Server 2008 and MySQL 5.x, so newer server versions are not covered by the stated compatibility
- Windows only
FAQs
Do I need to be a database administrator?
No. The vendor states that no DBA experience is required.
Do I need to install database client software?
No. The tool needs an ODBC or OLEDB database provider but not the official client software.
Which database versions does it work with?
The vendor lists SQL Server 2000 to SQL Server 2008 and MySQL 3.5x to 5.x.
Can it do more than MSSQL to MySQL?
You can also back up data into data files and export to formats like text files. Viobo sells separate migrators for other database pairs, such as MySQL to MSSQL.
System requirements
- Intel PII processor or above (P4 or K8 recommended)
- 128 MB of RAM or above
- Windows 95/98/ME, NT/2000, XP, Vista or 7