Exporting Database Information
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.
-
Open the
Server Administration tool and select the server configuration.
-
If the server configuration is running, click
(Shut Down Server).
-
Click
(Catalog Export).
The
Catalog Export
dialog box opens.
- Type, or browse for, the target path and location for the table catalog in the File name for exported table catalog field.
-
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.
-
Click
OK.