Command line version of SQL Server to MySQL converter

To perform batch conversion or call conversion procedure from an automation script you can use console version of MSSQL-to-MySQL called M2SAGENT.EXE. Find this file in MSSQL-to-MySQL installation folder. You can either run this tool directly from command line or call it from any script as well. The program supports the following command-line options:

In the following example the program converts local MS SQL database "db1" into MySQL database "db1 from mssql" on the remote MySQL server "mysqlhost" using table names file "c:\tabfile1.txt":

M2SAGENT.EXE --src=db1 --dest="db1 from mssql" --mysqlh=mysqlhost --mysqlu=administrator 
--mysqlp=the_passsword --tab_file=c:\tabfile1.txt

Table names file should be formatted as follows:

Table_1
Table_2
...
Table_N


Notes:

1. If you specified a profile, there is no need to specify any other parameters
2. You can omit 'mssqlh' or 'mysqlh' to connect local database server
3. You can omit 'mssqlu' and 'mssqlp' parameters to connect to MS SQL server using Windows authentication
4. It is necessary to specify 'port' parameter only if it differs from the default MySQL port 3306
5. If you omit 'tab_file' parameter, all database tables will be converted
6. If you omit 'mode' parameter, default mode 'overwrite the entire database' will be used
7. Command line parameters that contain spaces should be enclosed in quotes (for example --dest="my database")

MySQL character sets

This parameter specifies correct encoding of text values in the destination MySQL database. It can have one of the following values:

Please refer to MySQL documentation to better understand the concept of character sets and collations.

Have any questions? Contact us