There are many ways to export from SQL to MySQL. It is now introduced a graphical interface that does not need to be programmed. Direct use of SQL and MySQL.
A simple way to import the import.
The premise is that the SQL Server client and MySQL graphical interface management tool phpmyadmin are installed.
Open the SQLServer Enterprise Manager in the root directory of the console, create a new SQL Server group, select according to your own situation; then create a new SQLServer register to connect to SQL Server. Be prepared, start below:
First open the data conversion service, the new package, open the DTS interface, select the data source in the connection to configure. Select the destination file to be converted to, here I choose TextFile (Destination), after selecting the storage location of the file, let's create a task. Here we only select the conversion data task, and after the mouse with "Select Source Connection" "Selective Connection" is selected, we define the newly generated connection, in its property, destination, conversion Sequentially defined.
Execute the task, prompt success. Save tasks.
Then export data on the new task, with a wizard prompt, one of which selects "Source Database Replica and View".
This step has been exported to the destination file.
The next step is in MySQL, and when it is consistent with the structure that will be imported, select "to extract data from the text file, insert it into the data table:", then add the option, "send" is ok, browse, Data has been imported. To import the table already exists, the attribute name is also different, then build a table that is the same structure as the data to be imported and imported (can be performed as just now), then export "data in mysql" Structure, get the SQL statement, edit it in text files,
With the replacement function of the text editor, add the table name, column name, and finally paste it in the place where the SQL statement to import, execute, the data is imported.
If there is an error in the process, please check the configuration option to make sure it is correct.
