I recently detailed the steps for copying a form within the same database (
http://www.lantica.com/Forum2/cgi-bin/yabb/YaBB.pl?board=archived;action=display...; But I am unable to see how to copy a database within the same application (OriginalName).
Basically I am trying to copy database01 to database02, keeping the forms, and/or the records. I can always delete the records if not wanted.
==========================
Here are the steps that I followed (hope I got them all):
Open Sesame Designer,
Open Application OriginalName.db
From the tree, Application, Save as New Application, TempName.dsr
Open Application TempName.db
Set a designer file, TempName.dsr
From the tree, Manage a Database
For each database not being copied:
...............Select Manage Fields
...............In the Transaction Builder, Select a Database, Action=Delete a database, Add Transaction to Batch, Run Batch, Close.
For each database being copied:
...............Select Manage fields
...............In the Transaction builder, select a database, Action=Rename a database, enter the new name (database02), Add transaction to Batch, Run Batch, Close.
From the tree, Application, Save as New Application, TempName.db, replacing it when prompted.
Open Sesame Database Manager
File, Open Application, TempName.db
From the tree, Seach/Update, select the forms, press F10 to get all records in the record set.
From the tree, Mass Delete to remove all records.
File, Open Application, OriginalName.db
from the tree, Application Utilities, Merge Application, select TempName.db
======================
Whew! Now I can delete the TempName.db using Explore.
I now have a copy of the empty database, "database02" in addition to the original database, "database01" in the same application.
I had to include the steps to remove the existing records, or else when I copied a database with sub forms I got multiple blank records in the parent form. If I want the existing records I will need to go through a process of copy records from one database to another one.
This seems to work but is awkward, have I missed something? There must be an easier method.
Perhaps this capability can be added in a future release? Kind of like Q&A's File, Copy, Copy Design, With/Without records.