My database contains tables related together by foreign keys (Not for
Replication), and I want to design a transactional replication with queued
updating option between them, can I put each related table on a different
publication?
Saeed,
the general recommendation is to have the related articles in the same
publication, to ensure the same processing order is applied at the
subscriber. Is there any particular reason you want to split the publication
into two?
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Hi Paul,
our database is too huge, we have tables with millions of records, so if any
problem occured to any table or adding new column(s), we just want to start
reinitilize the effected table. not all related tables to minimize the
efforts on both the database and the network.
Thanks
"Paul Ibison" wrote:
> Saeed,
> the general recommendation is to have the related articles in the same
> publication, to ensure the same processing order is applied at the
> subscriber. Is there any particular reason you want to split the publication
> into two?
> Rgds,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
>
|||OK - then you could have different publications and ensure
that they synchronize in the correct order.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
Showing posts with label contains. Show all posts
Showing posts with label contains. Show all posts
Friday, March 23, 2012
Saturday, February 25, 2012
Registration Benefit Portal - Page Nopt Found
Hi, this text is taken from the FAQ and contains the same link the Registration email I received, which don't work (for me!). The link points to http://go.microsoft.com/fwlink/?LinkId=52054. Does anyone else have this problem?
NOTE: You can directly access the Registration Benefit Portal without need of a first or second benefit e-mail—as long as you have completed the registration process and use the same e-mail to login in to Passport at the benefit porta
Hmm, working now!
Subscribe to:
Posts (Atom)