September 10, 2009 at 3:22 am
Hello Geeks!
I want to know what's the best replication type according to my scenario.
1:My workmates update a local SQL Server 2008 database frequently. They need fast local database response.
2:Our hosted server needs be updated automatically.
3:My office do not have a static internet IP address. And I'm not good at VPN configuration and maintenance.
4:Even big latency or scheduled (hourly) can be accepted.
5:Our in-office database server is not always online (8:00AM to 6:00 PM online).
6:The schema is always changing. By rebuilding and re-importing. I hope the replication can be easy and robust.
Due to my inexperience, I think I'd best ask before I dive into the water.
Thank you.
😛
September 10, 2009 at 12:09 pm
I would not go for Replication in this case. It is too much of a hassle to deal with your particular scenario. I would say go for BCP or SSIS packages.
Just my two cents
-Roy
September 10, 2009 at 6:18 pm
In my understanding
1:BCP can not do differential update, every time I need to copy the whole database?
2:SSIS for this task needs a lot of data flow for hundreds of table, and it's slow for need to synchronize / compare data.
Am I right?
September 11, 2009 at 6:15 am
Yes, that is correct on the first part. I am no expert in SSIS so I cannot give you an advice on that. If you want to do replication, then the first time you set the replication up, script it so that you can run it again. But make sure that you have a drop script as well. From the scenario I saw on your first post, it seems like you will have tear down replication every now and then. So Script will make it easier.
-Roy
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply