Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Using Repository Engine Features with Older Databases

SQL Server 2000

Upgrading a repository database to version 3.0 makes repository engine 3.0 features available to the database. Depending on the DBMS you use to manage the database, however, you can encounter some exceptions. A few newer features are not supported on older versions of DBMS products. This topic provides more information about these exceptions.

DBMS Version Exceptions

The majority of repository engine features work identically for all supported DBMS products and versions.

The following table details which features are unavailable for certain DBMS versions when you upgrade a repository database to repository engine 3.0.

Database type Features
Microsoft® SQL Server™ 6.5 Bit properties cannot be added to existing tables.
View generation and view-based queries are not supported.
SQL Server 7.0 View generation and view-based queries are not supported.
SQL Server 2000 All features are supported.
Microsoft Jet 3.5 and later Bit properties cannot be added to existing tables.
View generation and view-based queries are not supported.
Some performance optimization techniques are not supported.

Note  Converting a Microsoft SQL Server database to a more recent version of SQL Server does not automatically generate views. Generating views and database conversion are separate tasks.

About Operating Systems

You can run SQL Server 2000 Meta Data Services on the following Microsoft Windows® operating systems: Windows 98, Windows NT® 4.0, and Windows 2000. Integration with Microsoft Distributed Transaction Coordinator (MS DTC) runs only on a computer that is running Windows 2000. For more information, see Integration with Distributed Transaction Coordinator.

See Also

Generating Views

IReposProperty2 Interface

Optimizing Repository Performance

Repository Databases

Retaining Legacy Components in a Repository

Upgrading and Migrating a Repository Database

Upgrading the Repository Engine

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.