Transactional Replication

• shwetha

  Ten Centuries

  Points: 1248

  More actions

  July 31, 2007 at 8:32 pm

  #92573

  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.

• philcart

  SSC-Forever

  Points: 47796

  More actions

  August 1, 2007 at 1:42 am

  #723782

  Please don't cross-post. See my reply in the other thread.

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