2 Replies Latest reply on Feb 28, 2013 4:33 PM by GordonBlake

    Merging multiple databases

    GordonBlake

      Title

      Merging multiple databases

      Post

           Background: I am developing a Filemaker 12 database to be deployed as a runtime solution to 10 different sites:

             
      •           On a regular basis the information from these 10 databases needs to be merged into one database
      •      
      •           Some of the information (e.g. names) need to be anonymised/removed, so returning the entire database file isn't an option (I think - is it possible to save a copy of a database with the names replaced with "xxx"?)
      •      
      •           The database has 12 tables
      •      
      •           Each site will be running different operating systems: Mac, Windows 7, Windows XP
      •      
      •           The keys for each site will be unique

           What is the best way to ensure that the merge is as painless as possible? My preliminary thoughts are:

             
      •           Each site does an export (spreadsheet? xml? csv?) to 12 separate files (one for each table), with names (etc) stripped out. The files get emailed to the central location
      •      
      •           A program (Java or Python) processes a folder of these files and combines them into 12 master files
      •      
      •           The master files get imported into the database

           but I'd be happy if anyone could suggest a better way.