May 7, 2010 at 8:40 am
i have requirement to sychronise data between two servers in different locations . the database is in simple recovery mode . can any one suggest the possible ways to synchronise this situatution .
replies are highly appreciated
thanks .
May 7, 2010 at 10:15 am
what does "sychronize" mean to you?
can you just take the backup at ServerA and restore it at ServerB, or does each server have data that their opposite server does not and you need to migrate in both directions?
how much data is involved? one table, a handful of tables, or a whole suite of interrelated tables?
Lowell
May 7, 2010 at 11:07 am
For what you need to synchronize.Can you specify it clearly.....
Try using third party tools...
May 8, 2010 at 7:51 am
Hi,
You can go for Merge Replication.It will keep the your data identical in both of the servers
Regards
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply