Regarding copying the data of a table from one DB to other DB

• dakshinamurthy-655138

  SSCertifiable

  Points: 5172

  More actions

  April 29, 2008 at 1:21 am

  #181743

  Hi,

  I have two DB's which has the same schema, i have a table called as test which stores the xml values, now i need to move all the non existing information of this table test from DB 1 to DB 2 of the same server, on a regular basis. So Please help regarding this.

  I am Using SQL Server 2000.

  With Regards

  Dakshina Murthy

• Rajesh Patil

  SSC Veteran

  Points: 219

  More actions

  April 29, 2008 at 1:39 am

  #808152

  Look into replication option or write triggers on the source table

• Mahesh Bote

  SSCrazy Eights

  Points: 9107

  More actions

  April 29, 2008 at 3:20 am

  #808199

  [font="Verdana"]

  Rajesh Patil (4/29/2008)

  ---

  Look into replication option or write triggers on the source table

  Replication is the best option over triggers.

  Mahesh

  [/font]

  MH-09-AM-8694