1 Reply Latest reply on Jun 28, 2010 8:30 AM by philmodjunk

    Merging/Sharing DB via e-mail/internet

    jonasg

      Title

      Merging/Sharing DB via e-mail/internet

      Post

      Hello everyone.

      I set up a filemaker database for my company, but I am not always there.

      Is there a way to sync a database file with another instance of it?

      I have FMP11, and so does the company. They would only add or change data, whereas I would make Layout/Script/Structural changes to improves the database.

      I know this sounds like open heart surgery, but I wonder if there is any Subversion-like approach that could merge two "branches" of the project back together..?

      Otherwise, I would have to get an up-to-date copy in the evening and do my work at night so they can resume work in the morning without having lost any data in the process...

        • 1. Re: Merging/Sharing DB via e-mail/internet
          philmodjunk

          Here are two alternative approaches. Most developers use one, the other or a mix of the two in such situations.

           

          1) After completing all your design changes, save a clone (no records) of your file. Take the file to work and import all records from the working copy into your clone. Update any auto-entered serial number fields to the correct next values. Swap your new file for the old. You can set this up to run with a script that moves from file to file importing and which computes and set next serial values. Thus, you can set this up to run for a few hours or even all night if necessary rather than doing it all manually table by table.

           

          2) Split your database file into two parts: a) an interface file with all scripts, layouts, and relationships between various table occurrences and b) a data file with just the data-source tables (and some times a few other relationships so auto-enter calcs, lookups and such work). SInce most upgrades require only changes to the interface file, you can often just swap out old inteface files for new whithout having to import data whenever you have a new version to install.