Monday, March 12, 2012

Merge Replication Issues.

Hi,
Is there a way to move views in a merge publication that will not verify the
view's dependencies during the initial synchronization?
Because of the large number of views and depth of dependencies in my
database it is very difficult to order the views properly for insertion into
the database. Because of this, I'm looking for information on some options
for Merge Articles that may get around this problem.
Thanks in advance.
Gautham.
Gautham,
one suggestion I can make is to partition your publication. You could have a
publication for the views, and a separate one for the stored procedures. In
this way, issues relating to the views will not prevent full
synchronization. If you know the correct required order of creation of the
views, then sp_addscriptexec can be used if you suspect the dependency info
in SQL Server is incorrect.
HTH,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment