Using advanced tools > Copying or importing table schemas
 

Copying or importing table schemas

Note  This feature is available when the Use advanced tools general preference is selected. See Using advanced tools.

You can consolidate tables from a multifile solution into one file. There are two methods for consolidating solutions:

Copy table schemas – Open source files to select and copy the tables you want. Then, paste the table schemas into the destination file.

Import table schemas – Import table schemas directly into the destination file. You can import just the schemas or import data with a single schema. (To import the data with a single schema, choose File menu > Import Records > File. See Importing data into an existing file.)

To copy table schema:

1. Open the database file that contains the table you want to copy.

2. Choose File menu > Manage > Database > Tables tab.

3. Select the table you want to copy.

4. Click Copy.

5. Open the database file where you want to paste the table.

6. Choose File menu > Manage > Database > Tables tab.

7. Click Paste.

To import table schema without data:

1. Open the database file into which you want to import a table.

2. Choose File menu > Manage > Database > Tables tab.

3. Click Import.

4. In the Open File dialog box, select the source file.

5. In the Import Tables dialog box, select the tables you want to import from the list and click OK.

6. In the Import Summary dialog box, click Open Log File to see a detailed log of the procedure, or click OK to close the dialog box.

Notes 

You must have full access privileges to the source and destination files.

Privileges from the source file are not retained. You must redefine privilege sets in the destination file.

Relationships between table occurrences are not retained.

If you created fields or tables and want to import them into the same file, close the Manage Database dialog box once before importing.

FileMaker Pro Advanced retains data source references to tables, fields, and scripts if they are valid when you copy or import. Check all data source references after pasting or importing to ensure they are valid.

Open the Import.log file, normally located in the folder with your destination database, for details on unresolved references and items that were renamed due to a naming conflict. If you’ve opened the destination database remotely or do not have write access to that folder, check the Documents folder.

Related topics 

Copying or moving fields between tables

Documenting database schemas

Importing data into FileMaker Pro Advanced