Post reply

Data Synchronisation - Best practice

  • November 7, 2014 at 5:52 am

    #298216

    Hi there,

    we are using the sync framework for syncing databases. Now to get the changes on the db, there are following possibilities:

    - CDC (good, because asynchronous, but not for high volume data)

    - CT (good, because lean, but synchronous and not für high volume data)

    - DML-Trigger (deprecated and synchronous)

    - Service Broker (good solution, controllable, good for high volume data)

    What would be the best practice to sync huge databases?

    Does anyone of you know about:

    - Programmatic solutions

    - Other solutions

    Thanks for your help in advance 😉

    Greetz
    Query Shepherd

  • November 10, 2014 at 6:22 am

    #1757409

    Nobody? ;(

    Greetz
    Query Shepherd

  • November 10, 2014 at 9:40 am

    #1757472

    If this is something you have to do on a regular basis, how about merge replication?

  • November 10, 2014 at 9:51 am

    #1757478

    We need more info on your requirements:

    Are these databases in the same location or do you need to sync over a WAN?

    Are these database pairs or are we talking about more?

    Is there only one database that is written to or or more?

    Are you talking about read only copies or two-way or multi-way sync?

    Is this for existing application(s) or is this for new application(s)?

  • November 12, 2014 at 6:35 am

    #1757964

    arnipetursson (11/10/2014)

    We need more info on your requirements:

    Are these databases in the same location or do you need to sync over a WAN?

    Are these database pairs or are we talking about more?

    Is there only one database that is written to or or more?

    Are you talking about read only copies or two-way or multi-way sync?

    Is this for existing application(s) or is this for new application(s)?

    The project manager definitely insists on the sync framework. The databases have to be synced over WAN, so we are using sync fx combined with wcf. We want to sync several client databases to a central server. We are only using a handful of tables, but later it is possbible, that we are using the whole database. At the beginning we only need one-way syncing.

    The question is, what is the best way to capture a lot of changes on a huge (3TB) database. Is there something better than CDC for this?

    Greetz
    Query Shepherd

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

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