Copy and link tables procedures

General description

This form is used to copy and link tables in DeMaSy databases.

Form logic

  1. To copy tables from a database to another, do the following:
    • In the original database list, select a database from which the table(s) will be copied
    • Click on the Refresh button to fill the original table(s) list
    • In the original table(s) list, select one or more table(s) to copy
    • In the destination database(s) list, select one or more database(s) the selected table(s) will be copied – you can also select all databases with the “+” button or remove all the selections with the “X” button
  2. To create linked tables in database B, pointing to original tables in database A, do the following:
    • In the original database list, select the database that contains the original tables
    • In the original table(s) list, select one or more tables
    • In the destination database(s), select one or more database(s) where the linked tables will be created
    • Click on the Link table(s) button. This will create links in database B, pointing to tables in database A.  Notice that this process will first delete the tables with the same names in database B
  3. To unlink tables, do the following:
    • In the original database list, select the database that contains the linked tables, then refresh the list of tables
    • In the original table(s) list, select the linked tables to be unlinked
    • The destination databases list is not concerned in this process
    • Click on the Unlink Table(s) button. The selected linked tables will be removed and replaced by the table that was previously pointed by the link
  4. Original Tables link location:
    • Displays the list of entries in the VersionLink table with their physical location
  5. Relink table(s):
    • ???

Form call