Import/Export TADB Database

You can take a backup copy of a TADB Database so that the database can be rebuilt later, or can be moved to a different location, if necessary. You can take a back up using the utility TADBMETAIE.exe.

Export TADB Database

  1. Open TADBMETAIE.exe located at <CIMPLICITY_Installation_Location>\Proficy\Proficy CIMPLICITY\TADB\METAIE.
  2. Select the (...) button. The Data Link Properties window appears.
  3. Select the Connection tab.
  4. Enter the Server Name of the SQL. The tcp/ip address of the server along with the instance id. Example: SQLSERVER\INSTANCE
  5. Select one of the following authentication options:
    • Use Windows NT Integrated Security
    • Use a specific user name and password.
  6. If you selected the specific user name and password option, enter the user name and password.
  7. Select the TADB database that you want to export from the drop-down list.
  8. Select Test Connection.
  9. Select OK.
  10. Enter the SQL password, and then select OK.
  11. Select Export.
  12. Select the location where you want to save the file.
  13. Enter a name for the file. The file type is .xml.

    Results: The TADB data is exported to the . xml file.

Import TADB Database

  1. Open TADBMETAIE.exe located at <CIMPLICITY_Installation_Location>\Proficy\Proficy CIMPLICITY\TADB\METAIE.
  2. Select the (...) button. The Data Link Properties window appears.
  3. Select the Connection tab.
  4. Enter the Server Name of the SQL server to which you want to import the data. The tcp/ip address of the server along with the instance id. Example: SQLSERVER\INSTANCE
  5. Select one of the following authentication options:
    • Use Windows NT Integrated Security
    • Use a specific user name and password
  6. If you selected the specific user name and password option, enter the user name and password.
  7. Select the TADB database to which you want to import the data.
  8. Select Test Connection.
  9. Select OK.
  10. Enter the SQL password, and then select OK.
  11. Select Import.
  12. Browse and select the database that you want to import.
    Important: The database to which you want to import the data must be configured as a TADB database.

    Results: The TADB data is imported to the selected database folder.