A Web site was previously made with ASP, and the database used was SQL Server, which now intends to use the Php+mysql architecture. Because the original site has a certain ranking, the direct revision of the words, will lead to a lot of error pages, the site rankings and results to recover from a long time, and the original site more data, manual turn is not realistic.
So now need a transfer of the MSSQL to MySQL, found on the internet a lot, either very complex, or simply can not be used (choose a few simple methods to try), now test the following methods of the simplest and most effective.
On-premises environment, install SQL Server to install MySQL:
1, MySQL tool use Navicat;
2, SQL in the installation, you need to install SQL Native Clent, and open the service;
3, create a data connection in Navicat, create a corresponding empty database,
4, after creating the database, open the database, select the Import Wizard;
5. In the Import Wizard, select the last
6, click Next, import inside select SQL Native Client;
7, Next, choose to use Windows NT Integrated security settings, database Select the database you want to convert, determine
8, as the table structure is exactly the same, then the full selection of data table bar, OK, because we are the new database, the inside is empty, then the default is to create a table, if you want to import into the existing table structure, then in the target table select the target tables to import, and then choose the field. Note In the 6th step, select the primary key to set the table!
9, if the addition of data, then select: Add the record to the target table, if you need the ID value consistent with the source database, select Copy, delete the target all data, and re-import from the source data
Note that when the import, if the table structure already exists, the key cannot be empty, if the data is added, then the ID value is empty, do not add the primary key, if an error occurs during the import process, according to the error prompt processing, this method absolutely can!