A simple way to convert SQLServer to MYSQL: Convert sqlserver to mysql

Source: Internet
Author: User

A simple way to convert SQLServer to MYSQL: Convert sqlserver to mysql

This conversion depends on the Navicat Premium tool.

First, move the database to the local SQL Server. I tried to directly transfer the database to another SQL server on the LAN. It seems that there is a problem, and I want to restore the remote database to the local backup.

1. Open Navicat Premium, create a database with the same name, and click "Import wizard" on the table ". Select "ODBC ".

  

2. Select the SQLServer provider and enter parameters.

  

  

  

3. Then, I tried my best to take the next step.

  

  

  

Here is a conditional query. If there are too many unwanted data or the field type is incorrect, you can set it here.

  

It's a success. You have to eat after work.

Supplement: This feature does not support data type conversion from SQLServer to MySQL. You need to set it manually. But there is no problem with importing data. The best way is:

First use the tool: mss2sql to convert SQLServer tables to MYSQL tables, and then use this tool to export data through ODBC.


How to convert a SQL server2005 database to a mysql database

Use MySQL Migration Toolkit:

Step 1: dev.mysql.com/downloads/gui-tools/5.0.html
Click Download to Download the Without installer (unzip in C.

Step 2: extract the file and unzip it to any folder.

Step 3: Run MySQLMigrationTool. Find the mysqlmigrationtool.exe file in the folder after decompression and double-click it. If you are prompted with JRE 5 and above required, you can download Java runtime enviroment 6 from security 360> Software Manager> Issue prerequisite, download and install it, and then run it again.) Click Next to Next.

Step 4: select the source database SERVER to be converted from the drop-down list on the Panel, such as ms SQL SERVER. enter the relevant database information, click advance, and enter the connection string jdbc: jtds: sqlserver: // 127.0.0.1 in the advance box; user = your database username; password = password; namedPipe = true: next

Step 5: Enter the target database. The default value is MYSQL. Enter the server user name and password. Click Next

Step 6: Configure relevant information as needed (you can also keep the default settings)

Step 7: continue to the next step and switch to the database

Step 8: after the conversion, you can use the MYSQL command or PHPMYSQL command to view the database you just converted to MYSQL.

I just answered the same question. I copied the answer directly.
Hope to help you

How to convert SQL Server database to mysql

In sqlserver, all tables, views, stored procedures, functions, and other objects are generated with SQL statements, re-created in mysql, and then the data is generated into files such as txt, import data in mysql.

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.