How to convert Sqlserver database to mysql database

I have a website that was previously created using asp.net. The database used is sqlserver, and I plan to use the PHP + MYSQL architecture. Because the original site has a certain ranking, a direct revision will lead to many error pages. It takes a long time for the website ranking and indexing results to be restored, and there is a large amount of data in the original website, manual conversion is not realistic.

So now we need a transfer scheme to convert MSSQL into MYSQL. I have found a lot on the internet, either complicated or useless at all (I have chosen several simple methods to try it ), the following method is the simplest and most effective method for self-testing.

In the local environment, install SQLserver to install MYSQL:

1. MYSQL tool navicat;

2. When installing SQL, you must install SQL native Clent and enable the service;

3. Create a data connection in navicat and a corresponding empty database,

4. After creating a database, open the database and select the import wizard ,;

5. In the import wizard, select the last

6. Click Next and select SQL native client for the import;

7. Next, choose to use windows NT integrated security settings, select the database you want to switch to, and then click OK.

8. If the table structure is the same, select all the data tables. OK. Because we create a new database and it is empty, the table is created by default, if you want to import data to an existing table structure, select the target table to be imported in the target table and select fields. Note that in step 1, set the primary key of the table!

9. If you want to add data, select: Add record to the target table; if you want the ID value to be the same as that of the source database, select copy, delete all the target data, and re-import from the source data

 

Note: During the import, if the table structure already exists, the key position cannot be blank. If the data is added, the ID value is blank. Do not add a primary key. If an error occurs during the import process, handle the error according to the error prompt. This method is absolutely acceptable!

This article is reposted from Shenzhen LDO Network Technology (www.ledaokj.com) For details, refer to: how to convert Sqlserver database to mysql database