Skip to end of metadata
Go to start of metadata

This is a list of objects that must be copied from itsprd to itsdev in order to have a successful clone of the override DB from production to development.

Tables (along with all corresponding constraints)

VISTA_DATA_SOURCE_INFO
VISTA_ENROLLMENT_INFO
VISTA_GROUP_INFO
VISTA_MEMBER_INFO
VISTA_OVERRIDE_INFO
VISTA_OVERRIDE_INFO_HIST

Views

OVERRIDE_VISTA_ENROLLMENT_INFO
OVERRIDE_VISTA_GROUP_INFO
OVERRIDE_VISTA_MEMBER_INFO

Triggers

IUDT_VISTA_OVERRRIDE_INFO
IUT_VISTA_ENROLLMENT_IF
IUT_VISTA_GROUP_ID
IUT_VISTA_MEMBER_ID

Sequences

VISTA_ENROLLMENT_ID_SEQ
VISTA_GROUP_ID_SEQ
VISTA_MEMBER_ID_SEQ

Send the request to someone on the DBA team (generally Jim Mathews)

  • No labels