Exporting database information

This topic describes how to export database information.

Database table names

The Catalog Export utility exports two application tables, Catalog_Tables and Catalog_Fields, into comma-delimited files. This tool is useful for database administrators because Catalog Export translates database tables and column names into identifiers used by the StarTeam Server. You can import and view the exported data in any application that supports comma-delimited fields. For example, if you save the file with a .csv extension, it will open in Microsoft Excel.

If you examine a column of data in the exported field catalog and find that one record has a surprising value (for example, all other records have a -1 in a column, but this record has a 16-digit number), the record may have been corrupted. However, we do not recommend that you delete any records, especially if you have not backed up the database.

Back to top

Exporting the database tables

To export database tables:

  1. Open the Server Administration tool and select the server configuration.
  2. If the server configuration is running, click GUID-E1CAFC1E-1F2D-4F4F-9B3B-A87E82C747D2-low.gif (Shut Down Server).
  3. Click GUID-E1CAFC1E-1F2D-4F4F-9B3B-A87E82C747D2-low.gif (Catalog Export). The Catalog Export dialog box opens.
  4. Type, or browse for, the target path and location for the table catalog in the File name for exported table catalog field.
  5. Type, or browse to, the target location and path for the field catalog in the File name for exported field catalog field.

    Note: Be sure to type the appropriate file extension for the application to which you want to export the files. By default, the utility specifies a .csv file.

  6. Click OK.

Back to top