同一类型下的两个数据库数据如何同步

--新增同步(在srv1数据库下建立触发器，同步更新、新增、删除)

有数据

srv1.库名..author有字段:id, name ,phone,

srv2.库名..author有字段:id, name ,telphone,adress

create     trigger     tr_insert_author    on     author

for     insert

as

set     xact_abort    on

insert     srv2.库名.dbo.author(id, name ,telphone)

select     id, name ,telphone    from     inserted

go

 

--修改同步

create     trigger     tr_update_author    on     author

for     update

as

set     xact_abort    on

update     b    set     name =i. name ,telphone=i.telphone

from     srv2.库名.dbo.author   b,inserted   i

where     b.id=i.id

go

 

--删除同步

create     trigger     tr_delete_author    on     author

for     delete

as

set     xact_abort    on

delete     b  

from     srv2.库名.dbo.author   b,deleted   d

where     b.id=d.id

go