数据源：ACCESS、SQL SERVER 2000，Windows XP/windows 2000。 目标数据库：SQL SERVER 2000 将分布在各个地区的工控数据采集采集到中间服务器汇总后，再传输到总数据库服务器。 A1——>B C A2——>B A1到B，SQL脚本： SELECT * INTO TEMP_02 FROM A1.A.dbo.O WHERE O.ID = O.ID and ((O.Date >= @Start_Date ) and (O.Date <= @End_Date)) and O.ID in ( Select M1.ID From A1.A.dbo.M1 where (M1.mDateTime >= @S_mDatetime) and (M1.mDateTime<=4.163399998842593e+004) ) ORDER BY O.ID A1+A2在B的汇总脚本： INSERT INTO S_T_Data (ID , SID , Datetime , Name )select @ID ,@SID ,Date , Cmpy from TEMP_02 B到C的SQL脚本： INSERT INTO X.C.dbo.T_DATA (ID , SID , Datetime , Name ) SELECT ID , SID , Datetime , Name FROM S_T_Data Where TransferMark = 0 Update S_T_Data Set TransferMark = 1 Where TransferMark = 0 and Datetime >= @End_Date
2019-09-21 10:09:16