November 10, 2014 at 6:22 am
Nobody? ;(
Greetz
Query Shepherd
November 10, 2014 at 9:40 am
If this is something you have to do on a regular basis, how about merge replication?
November 10, 2014 at 9:51 am
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
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 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply