Shulou(Shulou.com)06/01 Report--

There are many ways to export from sql to mysql. This paper introduces a simple method to import and export directly using the graphical interface of sql and mysql without programming.

The premise is that you have installed the sqlserver client and mysql's graphical interface management tool phpmyadmin. Open the sqlserver enterprise manager in the root directory of the console, create a new sqlserver group, and choose according to your own situation; then create a new sqlserver registration to connect to the sqlserver. When you're ready, here's the start:

First of all, open the data conversion service, create a new package, open the DTS interface, and select the data source to configure in the connection. Then select the destination file to be converted to. Here I choose Textfile (destination). After selecting the location of the file, let's create a new task. Here we only select the conversion data task. After the mouse with "Select Source connection" and "Select destination connection" selects the data source and destination respectively, we define the newly generated connection and define the source, destination and transformation in its properties.

Perform the task, prompting success. Save the task. Then export the data on the new task with a wizard prompt, one of which selects copy tables and views from the source database. This step has exported the data to the destination file.

The next step is to create a new table in mysql, and when it is consistent with the structure to be imported, directly select "extract data from the text file and insert it into the data table:". After adding the options, you can "send" and browse, the data has been imported. If the table to be imported already exists and the attribute name is different, first create a table with the same structure as the data to be imported and import the data (as you just did), then export the "data and structure" in mysql, get the sql statement, edit it in the text file, modify the table name and add the column name by using the replacement function of the text editor Finally, paste it in the place where the sql statement is executed where you want to import the table, execute it, and the data is imported. If there is an error in the process, please carefully check the configuration options to make sure they are correct.

[@ more@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.