Import/Export RCO Database

You can take a backup copy of an RCO Database so that the database can be rebuilt later, or can be moved if necessary. To export/import the RCO database (the data that outlines the RCO Site configuration) you must run the utility called RCODBIE.exe located at <CIMPLICITY installation>\rco\IE folder.

Export Tracker RCO Database

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

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

Import RCO Database

  1. Open the RCODBIE.exe utility located at <CIMPLICITY_Installation_Location>\Proficy\Proficy CIMPLICITY\rco\IE.
  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 RCO 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.

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