July 24, 2008 at 1:16 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.
thanks
Vinit Fichadia
July 24, 2008 at 10:37 am
Define your frequency of 'synchronization' requirement. Also, depends on the size of your database. Sounds like you really want merge replication, based on what little you've said. For that, you'll have to give M$ some cash, to buy a more robust version than SQL Express.
July 24, 2008 at 10:44 am
I'd think merge as well. Is the same data potentially being updated as well in both locations? If so, you need something like merge, or write your own merge, which is probably more expensive than buying a license.
If you update different data in each location, same database, you might be able to write some routines to move the data across. Red Gate (I work for them) has Data compare, which isn't too expensive and could help sync data.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply