Database

Check out data model using Visual Studio

Make changes (refer to https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2155053066 document)

Check in data model back to TFS

Send data model to DMI for review

If the data model gets rejected, DMI will send back an RDIMS doc detailing the problems

• Negotiate some of the problems with DMI and correct the rest. Update the doc and send the corrected data model to DMI again. This process might take several rounds depending on the volume and complexity of the changes.

DMI will send an email letting us know when they approve the data model

Save the new approved data model under: \\tc4s0a\Groups\AARA\AARAD\DBA\CCARCS\Data Model

Move the previous approved data model to: \\tc4s0a\Groups\AARA\AARAD\DBA\CCARCS\Data Model\Archive

Generate the scripts using erWIN (refer to https://tcmarin.atlassian.net/wiki/spaces/CA/pages/2155053066 document for steps). Carefully review the script as sometimes there are adjustments that need to be made.

Save scripts in: \\tc4s0a\Groups\AARA\AARAD\DBA\<APP_NAME>\Change Management

Comment out to the DROP table command from the script

Run the scripts in DEV.

• If errors occur while executing the script, cancel the script and save the output to analyze the errors and fix them. Resume running the script until no errors.

To move these changes to Acceptance / Production, open a change request (scheduled for, at minimum, 3 business days later).

• Acceptance change: Script will need to be sent to DMI team for review.

• Production change: In the plan, indicate that DMI will need to get the script from the ACC change.