Moving MySQL data into SQL Server without a DBA
You have a MySQL database, and the data now has to live in Microsoft SQL Server. You may not be a database administrator, and you don't want to hand-write export scripts. Viobo MySQL to MSSQL Data Migrator is a small tool built for that job. According to the vendor, no DBA experience is required.
Quick facts
- Purpose: migrate data from MySQL to MSSQL
- Platforms: Windows 95/98/ME, NT/2000, XP, Vista, 7
- Connectivity: ODBC or OLE DB provider, with no official client software needed
- Edition on this page: Business
Key features
Drag and drop migration from a tree view
The tool shows your databases as a tree structure. You drag objects from one database to another to migrate or back up data. It works much like moving files in Windows Explorer.
A task queue that runs several jobs at once
A task queue with multithreading handles several migrations at the same time. In the task list you can sort, delete, stop, start and remove all waiting tasks.
Your own SQL for the harder cases
If you know SQL, you can run SQL scripts, stored procedures and functions in the conditions test dialog. You can also define operation conditions so a migration covers only the data you want.
Character set choice and backup files
You pick the standard character set to use. Special table and field names are supported. You can also back up data to files in a folder you choose, and export to formats such as text files.
Who it's for
It suits people who need a one-off or occasional MySQL-to-SQL-Server move and prefer a visual tool to scripting. Database beginners can use the drag-and-drop interface. Experienced administrators can add their own scripts for advanced migrations.
Pros and cons
- Pro: a simple interface that needs no DBA background.
- Pro: no official database client software is required, only ODBC or OLE DB.
- Pro: runs several tasks at once.
- Con: the listed platforms are all Windows, so it is a desktop-only tool.
- Con: the vendor documents compatibility only with older database server versions.
FAQs
Do I need database administrator skills?
No. The vendor says DBA experience isn't necessary. Advanced users can still write their own scripts.
Do I have to install MySQL or SQL Server client software?
No. The tool needs an ODBC or OLE DB database provider, not the official client software.
Can it do more than migrate?
Yes. You can back up data to files in a folder you choose, and export to formats such as text files.
Can it run several migrations together?
Yes. Its task queue and multithreading let it process multiple tasks at the same time.
System requirements
The listing names Windows 95/98/ME, Windows NT/2000, Windows XP, Windows Vista and Windows 7. You also need an ODBC or OLE DB provider for your databases.