描述:数据库A中的表table1,实时同步到数据库B
1、在数据库A中设置访问数据库B的链接服务器。
2、在两个数据库之间表中,选择一个表,对其新增、删除、修改操作设置触发器,通过触发器实现数据同步到其他数据库的表。
-创建触发器,同步远程表_新增操作
CREATE TRIGGER SYN_RemoteTable_Insert
ON Table
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;
INSERT [vRemoteTable] SELECT * FROM inserted
END
GO
--创建触发器,同步远程表_同步操作
CREATE TRIGGER [dbo].[SYN_RemoteTable_Update]
ON Table
AFTER UPDATE
AS
BEGIN
SET NOCOUNT ON;
UPDATE vRemoteTable set ID=u.ID,Name=u.Name
FROM inserted u where u.ID=vRemoteTable.ID
END
--创建触发器,同步远程表_删除操作
CREATE TRIGGER [dbo].[SYN_RemoteTable_Delete]
ON Table
AFTER DELETE
AS
BEGIN
SET NOCOUNT ON;
DECLARE @ID int;
select top 1 @ID=IsNull(ID,-1) from deleted;
delete vRemoteTable where