Wednesday, March 7, 2012

replication

Using merge replication, we made some schema changes to the publishing
database. The changes included the addition of a 1 column to to different
tables, a modification to a view and the addition of 3 contraints. To do this
we created a new publication.
When I created the subscription for the changes and ran the sychronization,
everything except the views were copied over.
Any idea why?
Thanks,
Gracie
Gracie,
Have a look at the article properties of the view to check it is set to drop
if exists.
Also, have a look at the snapshot history to see if the view definition was
created, and the snapshot files themselves if they haven't yet been cleaned
up.
BTW, unless there was a specific reason for having another publication, this
isn't mandatory, and if the new tables are related to existing tables from
the other publication, you might be better adding them there, so as to keep
PK-FK changes together in one synchronization.
Rgds,
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