July 28, 2009 at 4:26 am
Hi All,
My current environment has recently changed from a 2 server, transactionally replicated setup (server A is the transactional application server, server B was a subscriber used for reporting purposes only).
Recently a new web server has been put in place and this required a merge replication setup, and with it the introduction of identity range management. I now cannot use the tables in the transactional publication that have the columns with the identity range management on them. I get the error message "Automatic identity range support is useful only for publications that allow updating subscribers.
Changed database context to
I thought the easiest way would just be to drop the transactional publication and add the report server as a subscriber to the merge publication, however i cant do this as its sql 2008 and the publication is 2005. For completeness the web server is also sql 2005.
Can anyone help me out on how i can get the replication back up and running the report server?
Thanks in advance
John
July 28, 2009 at 5:09 am
I "think" ive managed to sort it by dropping the merge replication and using transactional with updatable subscribers.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply