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.