INF: Understanding Microsoft Repository

• Microsoft SQL Server version 7.0
• Microsoft Visual Studio 6.0

SUMMARY

Microsoft Repository 2.0 is included with Microsoft Visual Studio 6.0 and Microsoft SQL Server 7.0. Microsoft Repository 2.0 uses the Open Information Model (OIM) -- a set of meta data specifications to facilitate sharing and reuse between tools and systems. OIM is a set of open, industry-standard data models that can be shared among software development and data warehousing tools.

You can preserve any Component Object Model (COM) object in the Repository. In SQL Server 7.0, it is normally used to save Data Transformation Services (DTS) packages with lineage information. When you install Microsoft SQL Server 7.0, the Repository engine is installed by default in the msdb database. A Microsoft SQL Server installation can contain multiple Repositories; however, DTS supports only use a single Repository database for each server in the Microsoft SQL Server Enterprise Manager console tree. This single Repository must reside in the msdb database. The tables that are part of Repository are the tables whose names start with Rtbl, Dbm, Dtm, Dts, Gen, Mds, Ocl, Olp, Tfm, Uml, and Umx. The stored procedures that are part of Repository have names starting with r_i.

There is also a Software Developer's Kit (SDK) available for the repository. You can download this SDK from http://msdn.microsoft.com/repository/downloads/sdk/default.asp. The most recent version of the Microsoft Repository SDK is 2.1b.

MORE INFORMATION

For more information on the Microsoft Repository, visit http://msdn.microsoft.com/repository/default.asp. Also see "Repository" in the SQL Server 7.0 Books Online.

Additional query words: rep metadata

Keywords : kbVS600 kbSQLServ700 kbDSupport kbinfo
Version : WINDOWS:6.0; winnt:7.0
Platform : WINDOWS winnt
Issue type : kbinfo