Working with Repository Databases in Meta Data Browser

Meta Data Services

Meta Data Services

Working with Repository Databases in Meta Data Browser

When you run Meta Data Browser as a stand-alone snap-in, you can register any Microsoft® SQL Server™ database that contains repository tables. Registered repository databases are listed in the SQL Server 2000 Meta Data Services folder. All registered repository databases are grouped together on the same level.

Upgrading Databases

After you register a database, you have the option of upgrading the database to the latest format. Upgrading applies the most recent repository SQL schema to a repository database that you formatted using a version of the repository engine that is older than the current repository engine. Although you can register repository databases created with earlier versions of the repository engine, upgrading gets the most current repository SQL schema tables that support new repository engine features. During the upgrade process, new tables are added, and data from existing tables is copied to the new table format. Custom tables that you create remain unchanged.

To upgrade a SQL Server repository database, right-click the registered database and then click Properties. This opens the Repository Properties dialog box. Providing the required information in this dialog box completes your option selections.

More Database Related Tasks

The following table contains links to topics that can help you learn more about related tasks. For more information about repository databases, see Repository Databases.

Topic Description
Selecting Browse Mode in Meta Data Browser Describes how to select End User, Power User, or Administrator browse mode. When working with a repository database, the scope of actions that are available to you depend on the browse mode you choose for the database.
Setting Display Options in Meta Data Browser Describes how to make optional items viewable in the browser.
Registering a Repository Database in Meta Data Browser Explains how to add a new repository database to the list of registered databases.
Editing Registration Properties in Meta Data Browser Explains how to edit registration properties.
Deleting Registration Properties in Meta Data Browser Explains how to delete registration information and thereby unregister a database.
Exporting to XML Explains how to copy repository data to an XML file.

See Also

Repository Properties Dialog Box

Repository SQL Schema

Upgrading From Previous Versions

Using Meta Data Browser

Working with Contents in Meta Data Browser

Working with Information Models in Meta Data Browser