...
Info |
---|
Data models are currently saved in \\tc4s0a\Groups\AARA\AARAD\DBA\<APP_NAME>\Data Model\ Stored procedures/packages are at http://tfsprod:8080/tfs/CivAv/CivAv_Database/_versionControl |
...
Software |
---|
TOAD | To access the database, run scripts, etc. |
erWin | To update data models for Data Management approval |
Other Information
Contacts |
---|
TCDIR database (MV001 table is a view from this DB) | Sandy MacPherson |
Data Model Changes
Expand |
---|
title | How to make data model changes and move them through the environments |
---|
|
Check out data model using Visual Studio Make changes (refer to ERWIN GUIDE 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 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\
|
...
Packages/Procedures: http://tfsprod:8080/tfs/CivAv/CivAv_Database/_versionControl
How To
Access to Database Passwords
...
Archive
Generate the scripts using erWIN (refer to ERWIN GUIDE 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. 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.
|