AnsweredAssumed Answered

Merging Two Database Files

Question asked by joelande on Jan 17, 2014
Latest reply on Jan 17, 2014 by davidanders

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?

Outcomes