Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: SS2005 Replication: Can you replicate constraints without reinitializing?

    We have a two SQL Server 2005 databases set up using Transactional Replication. My manager has asked me to set it up to replicate constraints (default, fk, et) on the tables in the main publication. I said sure, I can do it, but I will have to re-initialize the subscription. He said there was a way to do it without re-initializing the subscription. I cannot find anything in my research to indicate that there is a method to do so (via call sp_ functions, etc). Is it indeed possible to replicate constraints on replicated tables without re-initializing the who subscription? The reason he does not want me to perform a re-initialization is that we are a few weeks before moving into production, and a full re-initialization takes 1.5 days, which would impact system availability.

    Thanks in advance for any advice.

  2. #2
    Join Date
    Jan 2007
    Posts
    2

    ?

    Does anyone have any idea on how to do this?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •