Migrating MySQL To MS SQL Server 2000/2005/2008 database

Introduction:

1). In "Choose a Data Source" dialog, choose "MySQL Database ", then fill out server name (default is localhost), port (default is 3306), user name (default is root) and password; Press "Refresh" to automation enumerate all databases the MySQL Server, choose the database which want to be migrated, then click "Next" to continue.

2). In "Choose a Data Destination" dialog, choose "Microsoft SQL Server (Standard) " or "Microsoft SQL Server ( OS Authentication)"; Fill out the server name where SQL Server locating and the server port (default is 1433, or 1284 for SQL Server 2005 Express), plus, you want to offer an username and password when you use "Microsoft SQL Server (Standard) ". Press "Refresh" button, this program will enumerate all databases locating in the MS SQL Server automation, you can select a database directly, or input a new database name in "Database" field, program can create the new database in converting. Click "Next" to continue.

3). In "Select source Tables(s) & View(s)" dialog, program listing all the tables and views in the MySQL database, you can preview source table data via "Preview" button. Selecting the tables or views that you are preparing to convert. In here, you have a chance to change the destination table name at "Destination" column. There is an "Overwrite Database" option below the list (Notice: When you check this option, the destination MS SQL Server database will be removed, and all data will lose!). If you want to set more options for conversion, click "..." button at "Transform" column immediately.

4). In "Transform" dialog, there are some useful options for your conversion. You can only convert the table structure via check "Copy Structure Only" option, or check/uncheck "Copy Indexes"/"Copy Foreign Keys" to enable/disable copy MySQL indexes/foreign keys when converting. The "Transfer auto-increment" option is most usefully for you when you converting a MySQL table with a auto-increment field (e.g.: ID), sometimes, when you append data to a SQL Server table with auto-increment, perhaps you will receive a message like "Duplicable-keys...", you can uncheck this option to resolve it. Plus, you can change table/column case in "Table/Column Name" option or give a data filter (e.g.: [id]<100 etc) in "Records Filter (WHERE)" option (If you want to migrate all data let this option empty or 1=1). In "Field Map" list you can choose which table fields will be migrated and the field name, type, allow null, size, precision, default value. When all done, click "OK" to save your settings.

5). In "Execution" Dialog, click "Submit" to starting the MySQL to MS SQL Server migration. When conversion is running, click "Stop" to stop the conversion.

Finished.

If you have any questions or suggestions, please contact us. Thank you for your time!