Post reply

sync sql2005 & sql2000

  • September 8, 2009 at 7:23 am

    #156185

    Hello,

    Thare are 2 databases

    one is in sql 2005

    other is in sql server 2000

    How to implement a synchup process which will do the following?

    Any update/insert in Table A in sql server 2000 should trigger an update/insert in Table A on Sqlserver 2005 and viceversa.

    Inputs are welcome!

    karthik

  • September 8, 2009 at 11:12 am

    #1050661

    Any inputs?

    karthik

  • September 8, 2009 at 2:41 pm

    #1050802

    you have to create a linked server and use fully qualified table names in your trigger.

    Alex S

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

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