Post reply

Transactional Replication on SQL Server 2012

  • January 12, 2016 at 8:25 pm

    #1851468

    Hi,

    Let me try to answer you on that.

    1. you can, in fact, you can even use it even Server_Dist is up. That how T-replication works 🙂

    2. You can insert data to Server_Sub even if Server_Dist is up

    3. When insert into Server_Sub, it will use its own seed, meaning it will start from 1 onward

    4. like in 3, it will start from 1 onward and follow your seed

    5. If Server_Dist is back, it will continue to replicate, given its not down over the threshold you set in replication. Otherwise the subscription might expire and need to re-init again.

    6. answered in 5

    7. answered in 5

    8. not sure what you meant.

    In general, it might not be the way you look for. You might better off set "Not For Replication" for your ID field, which then it will follow the same seed of what you set in publisher (using different part of numbers. eg, starting from 1001 onward etc). You might also notice that you can update Server_Sub even Server_Dist is up, that will be something you should look out for. Do note that T-replication with updatable sub has been removed in sql 2012, if you want to have data replicate back, you can either use merge or peer-to-peer replication.

    Hope this helps.

  • January 15, 2016 at 12:34 am

    #1852162

    Dear Sir,

    Thanks for your reply.

    As suggested, I tried these steps except M-Replication.

    But the things did not executed as per expectations.

    I have a DB with tables having IDENTITY column, PK, FKs, Default bindings as values & function and a huge data in it etc.

    During T-Replication, when 1st DB snap gets executed with "Drop & Recreate Objects" method at Destination, all FK references and few default bindings (mostly those having functions as default binding) gets removed.

    Also even though IDENTITY column is setwith NOT FOR REPLICATION at both Publisher & Subscriber end, when data gets inserted at Subscriber, IDENTITY starts from 1.

    Need to do a manual DBCC to reseed IDENTITY value for every Tables that have IDENTITY column on Subscriber.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply