A Table Schema must be imported before a user can select Tables and Columns. Once imported, users can do the following: 

  • Add Tables to a G-Migrationn+ Configuration.
  • Select Sensitive Columns within one or more Tables for Synthetic Data Masking (SDM).
  • Add Data Subsetting Conditions to an added Table. 

Important: The imported Table Schema will be available to any G-Migration+ Configuration created within the selected Project and Project Version. Please note that if another Table Schema is imported afterward, it will be merged with the already imported one. 

In This Article

What is a Table Schema? 

  • A Table Schema contains the structure of one or more related tables within a database (i.e., Columns, Primary Keys, Foreign Keys, etc.).

  • It does not contain actual data and can be used to import the database structure into the GenRocket web platform.

When Should a Table Schema be Imported? 

  • Any time a subset of data or Synthetic Data Masking (SDM) needs to be performed between a source database and an identical destination database.

  • Note: 'Identical' means that they are the same type of database (e.g., MySQL, Oracle, etc.). A different schema can be defined within the G-Migration+ Configuration. 

Prerequisite Steps for Importing

  • The genrocket -xts command can be used to retrieve one, many, or all table schemas from a given database by connecting directly to the database via JDBC to extract the database’s schema. 

  • If this has not already been done, please do so before continuing. To learn more about XTS files and how to create them, click here.

How to Import a Table Schema

  • Select a Project and Project Version in the Project Dashboard
  • Select G-Migration+ within the self serve menu. 

  • Click the Import Table Schema button.

  • Click Choose File, browse to the Table Schema (.xts) file, and select it. 

  • Click the Save button once finished.

  • Click OK to close the dialog window. You will receive email notifications when this process has started and once the process has finished. 

    Note: The Queue information in the top right corner of the 
    G-Migration+ Management Dashboard can be refreshed and watched to see the import status. When a Table Schema is imported, you will see a number other than zero beside Waiting Queue Process.

  • Once finished, additional options will appear within the dashboard.

How to View the Imported Table Schema

Once the table schema is imported, it can be viewed by following the steps below: 

  • Click on the Show Table Schema button.

  • Select a Table Schema on the left to view its columns and relationships.

How to Change a Table Name

After the import, the name of one or more tables can be changed by completing the steps below: 

  • Click on the Manage Table Schema button.

  • Click on the Edit (Pencil) icon to change a table name.

  • Enter a new name and click Save.

  • The table will appear in the schema with the new name:

How to Delete a Table from the Imported Schema

Note: A table cannot be deleted if it relates to another table. 

  • Click on the Manage Table Schema button.

  • Click the Delete (Trash Can) icon to remove a table.

  • Click Yes to continue with the deletion.

    Note: If the table cannot be removed due to a relationship/dependency, the following message will be displayed, and it will not be removed.