Upgrade Guide › Upgrading Databases › Database Schema Changes

Database Schema Changes

If you are upgrading your CA DataMinder servers to 14.5, the database schema version is now 3.90. This version includes the following changes to enhance performance.

Indexes

(SQL Server only)

• For SQL Server 2008 and later, the following index now includes a WHERE clause:

  Wgn3EventParticipant.IX_Wgn3EventParty_QFlagsINode

• Temporary table TMP_WGN3ADDRRLS now has a new column SPID_KEY, with an new index IX_TMP_WGN3ADDRRLS_SPID_KEY on this column.

Constraints

(SQL Server and Oracle) To permit the introduction of new values for the QueryFlags attribute, the definitions of the following CHECK constraints have been amended:

• Wgn3Event.Event_QueryFlags
• WGN3EventParticipant.EventParticipant_QueryFlags

Note: Full schema details are available in the CA DataMinder Database Schema and Views Reference Guide.