Export from SQL Import to MySQL with graphical interface

There are many ways to export from SQL to MySQL, which is a simple way to import and export without programming, directly using the graphical interface in SQL and MySQL.

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. The table you want to import already exists with a different property name. This is the first to build a table with the same structure to import data and import data (as you can just do), and then export the "data and structure" in MySQL, get the SQL statement, edit it in the text file, using the text editor to replace the function, Modify the table name, add the column name, and paste it into the execution SQL statement where you want to import the table, and the data is imported. If there are errors in the process, check the configuration options carefully to ensure that they are correct.