远程同步数据库

EXEC sp_addlinkedserver@server=N'remoteserver', @srvproduct=N'',@provider=N'SQLNCLI',@datasrc=N'ip,port'goexec sp_addlinkedsrvloginN'remotedb',N'false',null,N'sqlid',N'sqlpwd'gobeginBEGIN TRYinsert into FinancialCalendarDataselect remotedb.*,'' as jin10from [remoteserver].[dbname].dbo.[tablename] remotedb left loop join tablename localdbon remotedb.[Date] = localdb.[Date] and remotedb.[Time] = localdb.[Time] and remotedb.CountryName = localdb.CountryName and remotedb.Content = localdb.Content and remotedb.DataTypeName = localdb.DataTypeName and remotedb.Source = localdb.Sourcewhere localdb.[Date] is nullEND TRYBEGIN CATCHPRINT 'Error Message: ' + ERROR_MESSAGE();END CATCHendgoexec sp_dropserver N'remoteserver',N'droplogins';go