Exporting/Importing data from all tables

[dsghs]

I have 10 different database files. They all have the same structure (tables, fields, etc), same scripts, same layouts.

But each has a different set of data.

When I update one of them (layouts, scripts, new fields, etc), I'd like to apply the updates to the other 9. What is the best way to do this? Right now I export all of the data by table and import this into a clone of the updated one. If export/import is the best way to do this, is there a faster way? Can I somehow import all of the fields from all of the tables at once from a filemaker file to another filemaker file?

[comment]

Why not simply keep one file with all the data?

[LaRetta]

And even one with the UI, so that far fewer design changes are required.

[bcooney]

You don't need to export, just import. And no, there's no master command. An import requires building a script that imports each table one at a time (and also sets the next serial_ID correctly).

Lots of posts on the forums, seach for "update."

[dsghs]

Why not simply keep one file with all the data?

Because they each serve a different company and I'm keeping all data totally separated.

I also don't want to wake up to one massive corrupted database and having 11ty people calling me at once.

You don't need to export, just import. And no, there's no master command. An import requires building a script that imports each table one at a time (and also sets the next serial_ID correctly).

Lots of posts on the forums, seach for "update."

Ah, so an update script. That sounds like a plan. Thanks!