2 Replies Latest reply on Jan 17, 2014 9:57 PM by davidanders

    Merging Two Database Files

    joelande

      Title

      Merging Two Database Files

      Post

           I have two database files.

           Each file contains numerous databases, records, layouts, scripts, and relationships, value lists, etc.

           The two files also have (external file) relationships linking databases between each other.

           I would like to merge the two files together, creating a single, unified database solution in a single file that includes all of the databases, layouts, scripts, etc.

           What is the best method for doing this?

            

           I know I could import the data, but that leaves the layouts and scripts behind for me to somehow copy manually, and then I would also have to re-link the fields on the layouts and the the buttons to the scripts.

           Is there anyway to merge the to files together with minimal work?

           I assume at a minimum I may have to rebuild the relationships that used to link the databases between the two files, but that would be a minimal amount of work (and I am hoping that after the old external relationships are re-linked to the new internal databases, the fields on the layouts will "find" themselves again and kind of "self-heal"...)

            

           Suggestions?