December 8, 2003 at 3:59 am
I am trying to setup Snapshot replication between two servers.
One is the publisher and distributor the other the subscriber server, which is a backup for the live server.
A number of the databases on the live server have identity columns which I need transferring to the subscriber.
How can I transfer these?
From various articles suggestions are writing scripts to recreate tables and copy data manually, which seems an arduous task if I have multiple databases. Any better suggestions?
thanks,
Andrew
December 9, 2003 at 8:31 pm
Snapshot replication will not create tables with IDENTITY "property". It will create the table but any column that has identity on the published will not have identity at the subscriber.You will need to create scripts for these tables. You can tell replication about these scripts.Alternatively, you can create the tables etc in advance specifying NOT FOR REPLICATION specified for the identity column. When you create the publication , specify one of the "DELETE DATA" options for the table.Replication will still handle the snapshot and delivery of the snapshot. You will not need to do this. XXX
December 11, 2003 at 8:02 am
quote:
Thanks. Managed to get it to work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply