synchronise b/w servers

  • 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 .

  • 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


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • For what you need to synchronize.Can you specify it clearly.....

    Try using third party tools...

  • 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