SQL server replication, and existing data

Question

If I have database A, and database B. Database B has existing data... Database A is empty.

If I turn on replication, with Database A being the publisher, and Database B being the subscriber ... will the exisiting data within Database B be deleted? Or will the data remain in Database B, and any new data added to Database A be replicated to B.

I'm thinking when you create the replication, the entire database B would be overwritten with database A data.

Is that right?

Philippe Grondier · Accepted Answer · 2011-05-16 05:29:19Z

2

when registering B as a suscriber to publication P based on dabatase A (P can be a subgroup of A, with filters, limitation on tables, etc), a snapshot of A, containing needed database structure and data, will be used to recreate B. Thus original B database and its data will be deleted.

answered May 16, 2011 at 5:29

Philippe Grondier

11.1k3 gold badges37 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

wtjones · Accepted Answer · 2011-05-16 02:46:09Z

0

From my experience, a subscriber will obtain the new data from the publisher. You will not be able to create a subscriber and simply append to database B. You may need to consider a different process. The Merge keyword could be an option. merge (MSDN)

answered May 16, 2011 at 2:46

wtjones

4,1814 gold badges38 silver badges42 bronze badges

1 Comment

Ibrahim ben Salah Over a year ago

Merge is not a reasonable option to use instead of replication, and we can not just assume the databases A and B are on same sql server instance as merge will requires that.

Collectives™ on Stack Overflow

SQL server replication, and existing data

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related