Syncronisation of DataBases

  • gvphubli

    Old Hand

    Points: 361

    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.

  • Andy Warren

    SSC Guru

    Points: 119676

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

    Andy

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

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