DBConvert for MS SQL & MySQL is a database migration tool for data conversion from MS SQL database to MySQL server and MySQL db to Microsoft SQL.
You can convert SQL data to MySQL or MySQL to MS SQL databases simply by configuring several options through Wizard interface or in command line mode. Ability to organize application work using command line parameters is supplemented with a scheduler so you can run the program without user input after task scheduling.
If a direct access to your MySQL/MS SQL base is denied (insufficient privileges) you can save your data into a dump file to overcome such restrictions. The primary function of the MySQL/MS SQL privilege system is to authenticate a user connecting from a given host, and to associate that user with privileges to select, insert, update, and delete a database. The SELECT, INSERT, UPDATE, and DELETE privileges allow you to perform operations on rows in existing tables in a database. The privilege system ensures that all users may perform only the operations allowed to them. Thus in case you have any privileges to create or modify a database on the target MySQL/MS SQL server there is an opportunity to save your data into a dump file. DBConvert for MS SQL & MySQL can transfer the content of the source database into a local dump file and afterwards you are enabled to send Dump file to MySQL server directly. The destination database in this case will be recreated with all the tables filled with the data according to MySQL or MS SQL statements . Using this dump file server administrator will add data to your MySQL/MS SQL database.
One of the key things of database managing is the ability to filter data during conversion. Integrated data filters allow users to retrieve only specific data for converted tables according to defined filtering criterias (conditions). Filters give you more control on data migration process.