3 Replies Latest reply on Feb 24, 2013 8:07 AM by philmodjunk

    Copy a Table

    jb362

      Title

      Copy a Table

      Post

           Is there any easy way to make a backup copy of a table?

           I'm using FMP Advanced.

           Thanks,

           Jerry

        • 1. Re: Copy a Table
          philmodjunk

               automated by script or manual?

               You can select copy from the Tables tab in Manage | Database to copy and paste a table,but this cannot be scripted.

               Import records can be scripted and "new table" is an option you can select for the target table. This will duplicate the table and the data in the source table's found set. Though I've never tried if from a script.

               It's simpler to back up the entire file or to export the data to a csv, tab or merge file to back up the data.

          • 2. Re: Copy a Table
            jb362

                 I wonder why Copy a Table doesn't prompt the user to copy just the structure or the structure and records?

            • 3. Re: Copy a Table
              philmodjunk

                   I can tell you "what" but not "why". It copies the table definition, not the data.