Previous Topic: Upgrading DatabasesNext Topic: Pre-upgrade Database Considerations


Database Schema Changes

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

New Indexes

WGN3UserProperty. IX_UserPropertyUserPropID

WGNPolicy.IX_WgnPolicy_PolicyName

New Constraints

WGN3Event.Event_QueryFlags

WGN3Eventparticipant. EventParticipant_QueryFlags

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