First, we need to know how to import mssqlserver data to the mysql database. First, we need to install mssqlserver2000 on your machine, at the same time, let your machine support php + apache + mysq... first of all, we need to know how to import mssql server data to the mysql database. First, we need to install mssql server 2000 on your machine, at the same time, let your machine support php + apache + mysql or php + iis + mysql. now, we can start importing data.
Use the following code to connect mssql server to php:
$mcn = mssql_connect('127.0.0.1','sa','1');mssql_select_db('hb',$mcn);
The mysql database connection code is as follows:
Okay, it's done. In fact, the method is very simple: connect two databases at the same time, then read the mssql data and save it to the data, and then save it to the mysql database one by one.
Permanent address:
Reprint at will ~ Please bring the tutorial URL ^