开发者

SQL Server 2005 replication triggers - how to?

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜