1 Reply Latest reply on Jan 25, 2011 9:02 AM by philmodjunk

    Combining older databases

    kthersh

      Title

      Combining older databases

      Post

      Right now I have three older FM databases, I need to get everything from each database combined into a new solution. The problem is the only way I've found to do this invloves some manual creation of value lists and copying layouts. I know you can import tables from one database to another that get's me the tables and fields. There is also a script import function I know of. But does anyone have any other good tips and hints to use while doing the imports? Thanks

        • 1. Re: Combining older databases
          philmodjunk

          One valid option is to leave the solution in separate files. Just because you can merge the three doesn't mean that you should. There are trade-offs to consider whether you merge the files or keep them separate.

          There is a tool called FMMigrator provided by a third party developer. I haven't used it myself, but it claims to make merging FileMaker files easier, so you might web search for them and check them out.

          If you do decide to go ahead and merge the files, a copy of FileMaker Advanced will be very valuable. The database design reports can be very handy for monitoring the merge process and looking for "disconnected" scripts and layout objects. And the Script Debugger can help you determine why an imported script didn't function as expected.