不同数据库数据同步

/*数据库test1和数据库test对相同表IC_SvcCardList同步操作*/
delete  b 
from  test1.dbo.IC_SvcCardList  b
where  not  exists(
select  1  from  test.dbo.IC_SvcCardList  where  SVCCardID=b.SVCCardID)
go

update  b set 
   SVCCardID=i.SVCCardID,
   ElectronState=i.ElectronState,
   CardNumber=i.CardNumber,
   Possessor=i.Possessor,
   PossessorID=i.PossessorID,
   [Password]=i.[Password],
   Tel=i.Tel,
   [Address]=i.[Address], 
   ValidityDate=i.ValidityDate,
   DisEnableDate=i.DisEnableDate
from  test1.dbo.IC_SvcCardList b,test.dbo.IC_SvcCardList i
where  b.SVCCardID=i.SVCCardID 

insert  test1.dbo.IC_SvcCardList
(SVCCardID,CardNumber,ElectronState,Possessor,PossessorID,[Password],Tel,[Address],ValidityDate,DisEnableDate)
select SVCCardID,CardNumber,ElectronState,Possessor,PossessorID,[Password],Tel,[Address],ValidityDate,DisEnableDate
  from  test.dbo.IC_SvcCardList  i
where  not  exists(
select  1  from  test1.dbo.IC_SvcCardList  where  SVCCardID=i.SVCCardID)

 

也可以使用游标遍历所有数据然后进行操作，用存储过程。