俩数据库,一个MS SQL数据库,一个Mysql数据库,要把ms中的一个表的部分字段的数据拷贝到mysql中的一个表中,寻大侠们帮忙 如ms sql的表article1(articleid,title1,content1,……)
mysql 的表arcitle2(id,articleid,title2,content2,……),把title1,content1的两个字段的全部记录拷贝到title2,content2的两个字段中
mysql 的表arcitle2(id,articleid,title2,content2,……),把title1,content1的两个字段的全部记录拷贝到title2,content2的两个字段中
然后在mysql中对于的表里import 里面的所有数据,就行
对于整个数据库也是一样。
这个也不会么。
<?php
$conn1 = mysql_connect("localhost", "username", "password") or die("failed to connect mysql server.");
$result1 = mysql_query("select * from article1", $conn1) or die("fail to connect mysql database");
$conn2 = mssql_connect("localhost", "username", "password") or die("failed to connect mssql server.");
$result1 = mysql_query("select * from article1", $conn1) or die("fail to connect mysql database");function fillTitle() {
mssql_query(
"UPDATE arcitle2 SET title2 = \'$title\'
WHERE articlid = \'$articleid\'", $conn2);
}function fillContent() {
mssql_query(
"UPDATE arcitle2 SET content2 = \'$content\'
WHERE articlid = \'$articleid\'", $conn2);
}while($arr1 = mysql_fetch_array($result1)) {
$articleid = $arr1["articleid"];
$title = $arr1["title1"];
fillTitle();
$content = $arr1["content1"];
fillContent();
}?>
mysql_close($conn1);
mssql_close($conn2);
未验证。另外我只接触过MySQL,mssql的操作都是按MySQL来的,不过按理说这两个的php操作应该是一样的(SQL语句通用)。
<?php
$conn1 = mysql_connect("localhost", "username", "password") or die("failed to connect mysql server.");
$result1 = mysql_query("select * from article1", $conn1) or die("fail to connect mysql database");
$conn2 = mssql_connect("localhost", "username", "password") or die("failed to connect mssql server.");
$result2 = mssql_select_db("article1", $conn2) or die("fail to connect mssql database");function fillTitle() {
mssql_query(
"UPDATE arcitle2 SET title2 = \'$title\'
WHERE articlid = \'$articleid\'", $conn2);
}function fillContent() {
mssql_query(
"UPDATE arcitle2 SET content2 = \'$content\'
WHERE articlid = \'$articleid\'", $conn2);
}while($arr1 = mysql_fetch_array($result1)) {
$articleid = $arr1["articleid"];
$title = $arr1["title1"];
fillTitle();
$content = $arr1["content1"];
fillContent();
}mysql_close($conn1);
mssql_close($conn2);
?>
数据库目录不能相同
启动脚本不能同名
端口不能相同
socket文件的生成路径不能相同