to guostong 如果这两个数据库位于两个数据库服务器(是相距较远的两台机器上)上,请教如何 写SQL语句?
比如: 一个在internet,另一个在你办公室局域网内.这个数据该怎么同步呢? 关注!
如果这两个数据库位于两个数据库服务器(是相距较远的两台机器上)上 建立DB LINK,然后用 insert into b1 select * from a1@DB_LINK
insert into B..B1 select * from A..A1在SQL 2000中,insert into B..B1 select temp.* from openrowset('SQLOLEDB','ServerA_Name';'sa';'Mypass','select * from A..A1') as temp其中ServerA_Name为远程服务器名
同时建立两个连接,分别 打开两个表,发现两个表中的数据不一样则由一个表insert into 另一个表中,dim cnn1 as connection dim cnn2 as connection dim rs1 as new recordset dim rs2 as new recordset set cnn1=new connection set cnn2=new connection cnn1.open strcnn ;strcnn为连接字符串 cnn2.open strcnn2 set rs1=cnn1.execute strexe set rs2=cnn2.execute strexe2 strsql="insert into table2 (field1,field2,......) values (" & rs1.field1 &"," & "......." & ") " rs2.execute strsql set cnn1=nothing set cnn2=nothing
如果是oracle数据库可以用copy 命令 copy from user/pass@zh9701:num_public_ask to fd97/pass99@zh9705 insert num_public_ask(num_id,num,name) using select num_id,num,name from num_public_ask where num_id='11A010842615';
如果这两个数据库位于两个数据库服务器(是相距较远的两台机器上)上,请教如何
写SQL语句?
一个在internet,另一个在你办公室局域网内.这个数据该怎么同步呢? 关注!
建立DB LINK,然后用
insert into b1 select * from a1@DB_LINK
select temp.* from openrowset('SQLOLEDB','ServerA_Name';'sa';'Mypass','select * from A..A1') as temp其中ServerA_Name为远程服务器名
dim cnn2 as connection
dim rs1 as new recordset
dim rs2 as new recordset
set cnn1=new connection
set cnn2=new connection
cnn1.open strcnn ;strcnn为连接字符串
cnn2.open strcnn2
set rs1=cnn1.execute strexe
set rs2=cnn2.execute strexe2
strsql="insert into table2 (field1,field2,......) values (" & rs1.field1 &"," & "......." & ") "
rs2.execute strsql
set cnn1=nothing
set cnn2=nothing
copy from user/pass@zh9701:num_public_ask to fd97/pass99@zh9705 insert num_public_ask(num_id,num,name) using select num_id,num,name from num_public_ask where num_id='11A010842615';