what's a good way to synchronize a sql server 2008 database from a 2005 database automatically?
Posted
by Keith Nicholas
on Stack Overflow
See other posts from Stack Overflow
or by Keith Nicholas
Published on 2010-04-19T01:54:41Z
Indexed on
2010/04/19
2:03 UTC
Read the original article
Hit count: 340
Ok, the scenario is... two servers, on completely different parts of the internet.
The sql 2008 database just needs to get data updates and schema changes. It doesn't need to send anything to the 2005 database. Basically just suck data and schema as efficiently as possible automatically as a scheduled task.
The database is quite huge.... but the changes per day are probablly around 20/30 megabytes of data/
I can't run any of the inbuilt replication on the 2005 database.
I've had a wee look at the Sync Framework, I think that might do what I want, but seems a bit painful and requires a bit of work to get going. I'm wondering if there is tooling out there to make this easier?
or?? not quite sure what my options are.
© Stack Overflow or respective owner
