Convert your MYSQL Database to MS SQL Database fast for FREE!!!
If you want to convert MYSQL database to MS SQL database this is the right tool for you.
Install Mysql to MsSQL converter. Download setup for EPIRTEO Mysql to Msql converter Win86 (Right click Save link As..) or Win64 (Right click Save link As..).
Setup ODBC Connection to MySQL Database
This article will not go through how to setup a MySQL or Microsoft SQL server, but make sure you have downloaded at least the MySQL ODBC Connector from here .
For this article, I downloaded the MySQL ODBC Connector 5.1.
The setup of this connector is pretty simple:
- Open your ODBC Data Source Administrator from the Control Panel -> Administrative Tools. Under the tab labelled as "System DSN", press the "Add" button.
- On the "Create New Data Source" dialog that appeared, choose MySQL ODBC 5.1 Driver and then press the "Finish" button.
- After that, a MySQL connection configuration dialog will appear. Add your MySQL database account information in it, preferably the "root" account which has full access to your databases in MySQL. In this case, my database is called "
tigerdb". Do not change the port to anything other than 3306, unless during yourMySQL server installation, you have defined something else.
- Press the "Test" button to ensure your connection settings are set properly and then the "OK" button when you're done.
Use Free Mysql to Mssql Conversion.
- Install Mysql to MsSQL converter. Download for Win86 (Right click Save link As..) or Win64 (Right click Save link As..).
- Fill up the Server Name, Authentication, User name and password. Then press Connect button to check for the connection. If successful, the Mysql Connect button will automatically Activate.
- For MYSQL connection Fill up the host name, User name, Password and Driver. Then press the Connect button. If successful, the Start conversion button will activate and you can now select the source database (Mysql) and destination database (MSSQL).
- Select the distination Database (MSSQL) and the source database (MYSQL).
- Press Start Button to begin the migration process. The process will convert the table structure, primary keys, foreign keys , indexes , default values and identities.
- Make a donation. Support the homeless developer :)
