Results 1 to 4 of 4
  1. #1
    Join Date
    May 2008
    Posts
    1

    Unanswered: Synchronize databases over network

    Hi,

    I have the following scenario:
    There are 3 web applications in a local network which all have a local copy of the same database. Each of them can alter their local database (just the data, not the structure), and every time that happens the databases of the other applications should be updated immediately.
    Are there any solutions out there for that? I found that most tools like slony only mirror one master database to multiple slaves, but I want every database to be able to be the starting point.
    There could also be a central sync server, like in subversion..

    Greets,
    Patrick

  2. #2
    Join Date
    Jan 2004
    Location
    In a large office with bad lighting
    Posts
    1,040
    Sounds like merge replication is what you need to look up in BOL.

    -- This is all just a Figment of my Imagination --

  3. #3
    Join Date
    May 2008
    Posts
    1
    Is there a reason you don't have all 3 web apps using the same DB backend? If you set them to use the same DB, you would avoid the need to have three sync'ed DBs.

  4. #4
    Join Date
    Aug 2005
    Posts
    75
    Quote Originally Posted by kevin9167
    Is there a reason you don't have all 3 web apps using the same DB backend? If you set them to use the same DB, you would avoid the need to have three sync'ed DBs.
    this was my first thought.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •