July 27, 2012 at 4:33 am
Hi, I have a table that needs to be exported to another server every night. I set up snapshot replication to do this. The table has an identity column. To my surprise this column never gets replicated to subscriber. It has NULL values in it. rest of the data is fine. While creating replication, in sp_addarticle I put 'Manual' option for @identityrangemanagementoption and not for replication. Am I doing it wrong? the table has millions of records. I have 2 questions.
1. What is the best way to populate that identity column temporarily?
2. How can I overcome this in snapshot replication?
Can someone please advise me?
Thank you very much
July 27, 2012 at 4:56 am
I'm a little surprised by this as Transactional and Merge both replicate identities. The destination is usually just a non-identity column.
Are you accidentally using vertical filtering?
July 27, 2012 at 6:11 am
I m not using any vertical filtering. The final goal is to transfer all the data including identity column. I never had this issue in transactional replication.
Thank you
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply