June 15, 2006 at 3:55 am
I have a transactional replication setup between my live and backup server and this works great for our restore program.
I have been tasked with setting this up between 2 other boxes but these boxes have databases which have triggers and indentity columns (which i am told can't be replcated), do scripts have to be run to get the replicated database to the correct form?
Is there a way of automatically scheduling production of the trigger/ identity scripts from the live server to a directory which could then later be used to update the replicated database?
i am using SQL SERVER 2000 (standard not enterprise) on windows 2000 server OS.
Hope someone can help.
Thanks
Barry.
June 16, 2006 at 7:31 am
Right click your publication and select properties.
On the 'snapshot' tab are options to run 'additional scripts' you can specify a script to run before or after the snapshot.
The triggers I would script ahead of time on the subscriber.
The identity columns can be replicated, they just loose the indentity property. They will just retain their values. Which is fine as long as the subscriber is read only.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply