Syncronisation of DataBases

  • Hello experts,

    I have built a small application with database[25 tables] on SQL server now what I want is I want the branch office also to use that same database for booking or reservation purposes but how should I make sure that both databases (one at HO and one in branch office are in sync with each other.

    or else how should I go about data transformation between the two databases..

    Pls. help me, by giving me Ur valuable and creative suggestions.

  • Transactional replication with immediate updating/queued updating subscribers is one way, merge replication would also work.

    Andy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply