Using Repository Engine Features with Older Databases
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 | 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
Optimizing Repository Performance
Retaining Legacy Components in a Repository