Results 1 to 2 of 2
  1. #1
    knetcozd is offline Member
    Join Date
    Jan 2011
    Posts
    1
    Rep Power
    0

    Default Sync two active databases

    I am in the process of building a small office application to keep track of stock , customers and so fourth.

    Coming from a web development background(PHP + MYSQL) i am used to dealing with one centralized database , I plan to have one dedicated PC which will serve as my database server and have 3 - 5 client computers interact with this one database.

    The problem is how do i make a portable version of the database for my laptop - so even if i am not in the office , i can sync with the main database server in the mornings allowing me to replicate a full copy of the database server to a local database on my laptop and sync again the database from my laptop to the main database the next day when i am back at the office.

    Both databases will be updated frequently between syncs - how do i ensure that after each sync , the data in the main database server is updated correctly ? , is this possible or should i rather develop an online solution ?

    I am using PostGresSQL.

  2. #2
    NigelRen is offline Member
    Join Date
    Dec 2010
    Posts
    4
    Rep Power
    0

    Default

    Keeping two independent databases in synch can be a nightmare. You open yourself to all sorts of issues - especially what happens when the same record is updated.
    IMHO - it would be better to develop some sort of online application. This could be a website or use a SOAP or REST service to your main database. This will always mean you have one view of your data - and your customers get a better service as you know your information is always the true position.

Similar Threads

  1. file sync from FTP to FTP
    By kgk04 in forum Advanced Java
    Replies: 0
    Last Post: 12-18-2010, 11:15 AM
  2. thered sync
    By miko5054 in forum Threads and Synchronization
    Replies: 2
    Last Post: 05-25-2010, 11:51 AM
  3. vertical sync
    By afraidofdark in forum Java 2D
    Replies: 0
    Last Post: 03-25-2010, 09:54 PM
  4. Thread sync problems!
    By barusk in forum Threads and Synchronization
    Replies: 9
    Last Post: 04-30-2009, 06:08 PM
  5. project is out of sync with file system?
    By anthrax in forum Threads and Synchronization
    Replies: 1
    Last Post: 03-04-2009, 06:19 PM

Posting Permissions

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