Post reply

Transactional Replication and no Primary Keys

  • November 27, 2008 at 5:40 am

    #198222

    Hi Team

    This is my second post to SQL Server Central. My first post was very helpful and i did get replies for all questions that was asked. Thanks for the support guys.

    I have just started to work with SQL and finding out new things everyday which helps me to do my job.

    The next task which has come is doing a replication. I would like to do a unidirectional replication where in data flows only in one direction but i would like to do this on a scheduled basis.

    I have 2 servers one which will act as the Publisher and Distributor and the second one will act as the Subscriber.

    I have setup the Distributor and was following the steps to do the Publishing. It came as far as selecting the tables(articles) which needed to be published.This database that i am using does not have any primary keys for any of the tables. So i am stuck at that bit. ( i have used transactional replication).

    I would need some guide in selecting the replication technique and also the process.

    Thanks

    Thomas

  • November 27, 2008 at 6:01 am

    #904275

    If you have no primary keys (aside, why not?) then you cannot do transactional replication. You can use snapshot, which will copy the entire database over at scheduled intervals, but that's the only option with no primary keys.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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