Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Add Article on Merge Replication

156 views
Skip to first unread message

Marcelo Colla

unread,
Jan 2, 2003, 10:34:16 AM1/2/03
to

Can anyone help me with this?

I have a merge replication with one publisher and one subscriptor
and this works fine, but I need to add one new article without resent all
snapshot database so the quention is how I can apply one article without
reaply all the first snapshot ?,
Thanks for all.

Marcelo Colla


Hilary Cotter

unread,
Jan 2, 2003, 12:25:31 PM1/2/03
to
the easiest way to do this would be to create a seperate
publication for this new article.
>.
>

Michael McPheat

unread,
Jan 2, 2003, 7:52:54 PM1/2/03
to
Even though replicatiopn requires you to generate the new snapshot, I think
you will find that only the schema and data changes will be merged at the
subscriber rather than the whole snapshot being applied.

-Mike

"Marcelo Colla" <mco...@bol.com.br> wrote in message
news:OAGOGSnsCHA.456@TK2MSFTNGP09...

Hilary Cotter

unread,
Jan 4, 2003, 12:11:28 AM1/4/03
to
My understanding is that if you create a merge publication
and do a nosync with your subscribers merge replication
metadata and merge replication tables and triggers will
still be snapshotted to the subscriber. If you do a sync
the data will also go to the subscriber.

>.
>

Michael Hotek

unread,
Jan 6, 2003, 5:08:14 PM1/6/03
to

You can add the article to the existing publication. The wizard will tell
you that it is going to invalidate everything and resnapshot it. Ignore
that message. It will generate a snapshot for only the article you added in
and then transfer that to the subscriber.

--

Mike
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
http://www.mssqlserver.com


0 new messages