Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2005
    Posts
    22

    Unanswered: Replication Issue

    Hi,

    We have about 30 tables and all the tables are independent, don't have any primary and foreign key constraints (but have clustered and non clustered indexes) on all the tables, our dba's are asking to create the keys for the replication purpose.My question is primary key and foreign key constraints are must for replication?Please respond.

    Thanks in advance
    BSR

  2. #2
    Join Date
    Jan 2003
    Location
    Geneva, Switzerland
    Posts
    353
    You need a unique index - ie something that will uniquely identify each row. This does NOT have to be done via a PRIMARY KEY declarative constraint, however.

    Michael

  3. #3
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    If you know any combination of columns that will trun out to be UNIQUE. Then really you don't strictly need any cDDL change at the primary although good practice.

    The column combo that represent a unique record for a given table must be part of your repdef.

  4. #4
    Join Date
    Dec 2005
    Posts
    22
    We have unique clustered indexes on all the tables, so we should be okay?

    Thanks,
    BSR.

Posting Permissions

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