Post reply

Database Transactional Replication -

  • July 31, 2007 at 8:37 pm

    #68873

     Thanks! in advance for the Suggestions or ideas!

    I need to replicate few tables for every 10 minutes from a production database and would like to implment this by setting up Transactional replication only, but unfortunately not all the tables have primary keys. 

    Can any one suggest workaround for this scenario?

    Workaround: what I thought is... we can create an "id" column in each table that doesn't have a primary key and then we can use these tables for transaction replication. Is this do-able???  Does this work???

     

    Regards.

  • August 1, 2007 at 1:42 am

    #723783

    You have to have a primary key for transactional replication to work. When you say 'create an "id" column in each table', I presume your thinking of creating an identity column. If so, make sure that you don't make them clustered (this is done by default).

    --------------------
    Colt 45 - the original point and click interface

  • August 1, 2007 at 12:44 pm

    #723980

    Even I pressume that id column means identity column and it is a good idea. If the table is really big and millions of rows then be sure the data type to hold big numbers (bigint).

     

     

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

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