Post reply

Sync tables

  • August 23, 2013 at 2:59 pm

    #282398

    Hi,

    what are the best options to sync one table between two separate SQL Server databases(Same domain). Thanks.

  • August 23, 2013 at 4:10 pm

    #1644602

    Change tracking?

    ADO Sync Framework?

    Merge replication?

    BULK INSERT?

    SSIS?

    Triggers?

    Service Broker?

    There are plenty of options, but which is the best depends on your situation - which we know nothing about.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]

  • August 23, 2013 at 4:14 pm

    #1644604

    Red Gate's SQLCompare and SQLDataCompare?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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