You can equip the clone copy with a script that opens the original and imports all records from all tables and that also updates next serial values on any fields with an auto-entered serial number setting. (Or you can avoid the need for a serial number update if you use auto-entered Get ( UUID ) generated values for your primary keys.)
Thanks Phil, it seems to work.
To be certain I understand:
In the import records script step dialog, I need to leave the "perform auto enter options" unchecked, so that the source records keep their source Primary Keys.
The Set-Next-Serial-Value script step is performed after the table import ( with a value set to something like "last record's primary key +1 ) so that I will not have two identical Primary keys.
You have the idea, but I seem to remember testing the import of records into a table with an auto-enter serial number field and with auto-enter options enabled and didn't get new serial numbers as long as there was already a value in the field. But my memory isn't perfect, so don't take that as a given--run a test of your own on a test copy and see what you get. But generally speaking, you don't want that option enabled for an import records used for this purpose anyway.