Is it possible to have more than one transactional replication publications
which will be containing differenr list of tables and will be synchronizing
at different times.
If yes pls. tell me how ?
Thanks in advance.
I'm not too sure I follow the question, the process to create a second
publication is much the same as the first as far as the selection of tables
is concerned. Each one will have different jobs which can be scheduled. Make
sure the second publication is configured to have an independant
distribution agent before creating the subscription so the synchronization
times can be different.
HTH
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment