Skip to main content

(Deprecated) Data Management Tool

This tool is used for migrating GT Workcenter eForms created in one database to another database smoothly and easily.

Source Database Steps​

Navigation: Manage GT eForms 3.x > GT Technical Setup > Data Management

Data Migration Tab​

A screenshot of the Data Migration tab

Form Setup Migration Section​

This grid contains a list of all of the forms that have been created in the source environment.

Message Catalog Migration Section​

This grid contains a list of the message catalogs used by the forms listed in the Form Setup Migration grid. The list of message catalogs is generated dynamically based on the currently selected forms.

It should be noted that you CANNOT generate a DMS script that both exports forms AND deletes others at the same time. If you select a form for export, every row’s delete check box will deactivate. Likewise, if you select a form for delete, all of the export check boxes will deactivate, too.

Steps to Select Forms and Associated Message Catalogs to Be Exported​

Steps:​

  1. Select the forms that need to be migrated to the target database.

A screenshot of the Form Setup Migration section with the Training Award Form checked for Export

  1. Once a form type is selected for export, the Message Catalog Migration grid will populate with the message catalogs used by form(s).

A screenshot of the Message Catalog Migration section populated with three messages

  1. If this is the first form of its form family that you are migrating, you’ll need to check the Export Form Family checkbox before proceeding with generating the DMS scripts.
  2. At this point, you have a few choices as to how you want to generate the DMS scripts:
    1. If there is no need to migrate the corresponding message catalogs and/or messages, you can click the Generate DMS Script button and the Export and Import DMS scripts will be generated. (Skip to step 5 for further instruction).
    2. If you need to migrate an entire message catalog, you can simply check the Export Entire Catalog check box for the necessary rows. Once you’ve selected the catalogs that need to be migrated, click Generate DMS Script. (Skip to step 5 for further instruction).
    3. If you need to migrate only select messages from the referenced message catalogs, you can click the Select Messages button on the corresponding row to select the individual messages that are specifically needed.

      1. You will see a page that looks like the following: A screenshot of the Select Messages window

      2. Simply check the Export check box for each of the messages that need to be migrated and click OK. (Skip to step 5 for further instruction).

    4. You can also select certain entire catalogs for migration, and then only select certain messages for a given catalog depending on your needs.
  3. Once you’ve clicked Generate DMS Script, the export and import DMS scripts will populate into the Export DMS and Import DMS scripts located at the bottom of the page:

A screenshot of the Export DMS nad Import DMS fields with a script populated

  1. Note – The Data Management Tool does not generate the SET LOG and SET INPUT/OUTPUT lines. Those will need to be added manually to Data Mover.