Post reply

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

  • 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

  • April 29, 2008 at 1:39 am

    #808152

    Look into replication option or write triggers on the source table

  • 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

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

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