Using merge replication do schema changes made to the publisher automatically get replicated to the subscriber or is it necessary to reinitialize the subscription.
Thanks,
Lance
Replication Newbie
Assuming you're using sp_repladdcolumn, sp_repldropcolumn then it is
automatic.
HTH,
Paul Ibison
|||Thanks, What about new tables, indexes, and constraints?
|||Lance,
for new tables, you can use sp_addmergearticle. When you add the article,
you can choose whether to take indexes, constraints using @.schema_option.
HTH,
Paul Ibison
sql
Friday, March 23, 2012
Merge Replication Schema Change
Labels:
automatically,
database,
merge,
microsoft,
mysql,
necessary,
oracle,
publisher,
reinitialize,
replicated,
replication,
schema,
server,
sql,
subscriber
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment