Post reply

Need recommendations on Replicating(sync a table ) SQL 2012 to SQL 2000 by any means...

  • October 29, 2014 at 10:31 am

    #291988

    Hi All

    Please recommend the possible workaround to sync 2 tables from 2012 to 2000.

    Note:

    Users will update both DBs. [/b]

    appreciate your response!

    Thank you...

  • October 29, 2014 at 11:26 am

    #1755604

    Will they be updating both tables on both servers?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 29, 2014 at 11:29 am

    #1755606

    Yes

  • October 29, 2014 at 12:46 pm

    #1755622

    Upgrade the 2000 box to 2012.

    Other than that, where both servers get updates that need to be replicated, your only option would be a home-grown replication.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • October 30, 2014 at 8:07 am

    #1755780

    when I research online, ppl are following;

    Dual Replication/Log shipping:

    From 2000 server to 2005/2008 and from 2005/2008 server to 2012 server.

Viewing 5 posts - 1 through 4 (of 4 total)

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