July 28, 2008 at 12:59 am
Hi all,
we have two servers one in india and other in US, now we are using free version of sql server which allows only subscribers in replication, so we have replication from india to US.
now our data will be updated on US server, so we need a mechanism (not replication) in which data updated on US server also gets reflected on india server.
so after a bunch of research, i have left with only one approach, which might be feasible
what i'll be doing is truncate all the data from india server and write all the data to india server from US server using sqlbulkcopy, as doing replication would take same amount of time as taken by this approach
what do you all suggest.
pls respond asap
thanks
Vinit Fichadia
July 28, 2008 at 7:41 am
Hi,
I'm not clear on the actual requirements you have for this "replication" mechanism, but if all you do is overwrite data each night, why not schedule a task that takes a full backup from the US server and restore it on the India server each night?
If you have to to merges, then best of luck.. a bulk copy mechanism is not going to cut it!
Regards, Rob
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply