July 22, 2016 at 6:15 am
Hi,
We are looking to replicate certain tables in a database, I know you can select articles in the setup of the subscription.
I've always used "restore from backup" to create the DB and then apply create but this has always been a full backup so do I need to create a backup of just the tables and restore that or do a full backup and restore and then drop the tables I don't need etc..
Steve.
July 22, 2016 at 6:38 am
You can create a new database at the target and set up replication to that.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
July 22, 2016 at 6:42 am
Hi thanks for the response.
Do I create the DB on the new subscriber with just the tables I want to replicate or a full DB backup and restore?
July 22, 2016 at 8:24 am
When I've done it in the past, just a standard empty database creation with the tables selected for the publication created and populated when it's created option used.
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply