Post reply

Sync Tables

  • November 17, 2015 at 2:51 am

    #322321

    Hi Experts,

    Is there anyway to sync few tables of two live databases which are hosted in different servers?

    TIA

  • November 17, 2015 at 3:23 am

    #1840245

    How often does the tables need to be merged?

  • November 17, 2015 at 3:34 am

    #1840247

    Ratheesh.K.Nair (11/17/2015)

    Hi Experts,

    Is there anyway to sync few tables of two live databases which are hosted in different servers?

    TIA

    Is that a two-way sync?

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 17, 2015 at 3:34 am

    #1840248

    Thanks Anthony.

    Every 10 minutes.

  • November 17, 2015 at 3:35 am

    #1840249

    Phil Parkin (11/17/2015)

    Ratheesh.K.Nair (11/17/2015)

    Hi Experts,

    Is there anyway to sync few tables of two live databases which are hosted in different servers?

    TIA

    Is that a two-way sync?

    Thanks Phil,

    Yes it ha to be two way or some and one way for other a few.

  • November 17, 2015 at 3:42 am

    #1840250

    Sounds like merge replication may be the best option

  • November 17, 2015 at 10:22 pm

    #1840523

    Using MERGE is your best option. You can control each of the conditions

  • November 17, 2015 at 11:58 pm

    #1840530

    MERGE is good, but difficult to manage with key conflicts etc.

    You may have to redesign your identity ranges on each table, or put a method together on how you are going to deal with conflicts.

  • November 18, 2015 at 12:24 am

    #1840534

    johnwalker10 (11/17/2015)

    Using MERGE is your best option. You can control each of the conditions

    I can't see MERGE working in a two-way sync solution, unless there are never any deletions and there are no identity columns ... then, maybe.

    Anthony's suggestion of merge replication would work, but it's s sledgehammer. If it were me, I would think of using Change Tracking.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 18, 2015 at 1:40 am

    #1840550

    Phil Parkin (11/18/2015)

    I would think of using Change Tracking.

    Always forget about CDC, just one of them things I have never used so never crosses my mind.

  • November 18, 2015 at 2:01 am

    #1840558

    anthony.green (11/18/2015)

    Phil Parkin (11/18/2015)

    I would think of using Change Tracking.

    Always forget about CDC, just one of them things I have never used so never crosses my mind.

    I've used it only once, placing me just slightly ahead of you in the knowledge stakes 🙂

    Note: CDC and CT are different.[/url]

    CT is more lightweight and may be adequate in this situation.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • November 18, 2015 at 2:05 am

    #1840559

    Thanks for that link, will take a look more into CT then

  • November 18, 2015 at 3:27 am

    #1840579

    Thanks Anthony, Phil and John.

    New to me that CDC and CT will help update data between two tables. Thanks Again Phil.

Viewing 13 posts - 1 through 12 (of 12 total)

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