开发者

SQL Server 2005 replication triggers - how to?

开发者 https://www.devze.com 2022-12-21 14:07 出处:网络
I need to run the replication of one table in SQL S开发者_开发技巧erver 2005. Replication should be one way. From 1 master server to many children servers.

I need to run the replication of one table in SQL S开发者_开发技巧erver 2005. Replication should be one way. From 1 master server to many children servers.

I thougt about snapshot replication, but I don't want to schedule it only for example every hour/minute ect. (I know how to do this.) but ALSO triggered it evry time new data appears in master server's table.

Is there a way to do it? Which type of replication should I use and how to configure it?


Can you use transactional replication?

http://msdn.microsoft.com/en-us/library/ms151176%28SQL.90%29.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号