Renaming a table

If you rename a database table that is used in the configuration, the table will no longer be recognizable to iBridge Designer. Therefore, you need to rename the corresponding table in the configuration.

To rename a database table in the configuration:
  1. With all configuration files closed, select Tools > Fix Configuration > Renamed Table.
  2. In the Configuration dialog, first enter the configuration file that you want to fix, including its file path. You can browse to the file by selecting the browse button next to the first text box (marked ...).
  3. The file name you entered with the suffix (fixed) is automatically entered in the second text box on the Configuration dialog. At this point, you can do one of the following:
    1. If you want to create a new configuration file in the same location as the original configuration file with the added suffix (fixed), leave the entry as it appears.
    2. If you want to create a new configuration file with a different name or in a different location, browse to the correct location and type the new file name in the Filename box. A new file will be created in the location you specified containing the fixes you perform.
    3. If you want to overwrite the original configuration file, click the browse button next to the second text box, and navigate to the original file. This is not recommended however, because if any problems occur the original configuration file is not recoverable.
  4. The Renamed Table dialog opens, displaying the tables it can no longer find in the left panel and the new tables it has found on the right. Select the old table name and the new table name then click Rename to rename the table.
  5. Repeat step 4 for any other tables that need to be renamed.
  6. The Configuration Fixer detects whether there are any more tables to rename. If there are not, you will be prompted to save changes. Click Yes to save changes and No to discard all the changes that you have made.
  7. Open and re-issue the database for the changes to take effect.