SQL Export to MySQL

MySQL has a lot of ways to export from SQL to MySQL, and now introduces a graphical interface that uses SQL and MySQL directly without programming.
A simple way to import and export.
The prerequisite is that you have installed the SQL Server client and the MySQL graphical interface management tool phpMyAdmin.
Open SQL Server Enterprise Manager under the console root, create a new SQL Server group, choose your own situation, and then create a new SQL Server registry to connect to SQL Server. When you are ready, the following begins:
First, open the Data Transformation Service, create a new package, open the DTS interface, and select a data source to configure in the connection. Then select the destination file that will be converted to, here I choose textfile (Destination), select the location of the good file, we have to create a new task. Here we only select the Transform Data task, with the "Select Source Connection" "Select Destination Connection" Mouse to select the data source and destination, we define the newly generated connection, in its properties, the source, the purpose, the transformation is defined in turn.
Perform the task, prompting for success. Save the task.
Then export the data on the new task, with the wizard prompting you to select Copy tables and views from the source database.
This step has already exported the data to the destination file.
The next step in MySQL is to create a new table, in line with the structure that will be imported, directly select "Extract data from a text file, insert into the datasheet:", after the option is added, "Send" on it, browse, the data has been imported. To import a table that already exists, and the name of the property is also different, then first build a table with the same structure as the data to import and import data (as you just did), and then export the "data and structure" in MySQL, get the SQL statement, edit it in the text file,
Using the replacement function of the text editor, modify the table name, add the column name, and paste it in the place where you want to import the execution SQL statement of the table, and then execute it and the data is imported.
If there are errors in the process, check the configuration options carefully to ensure that they are correct.