Databases

Modified on 07/07/2018 13:31 by Tester — Categorized as: Database, Navigation, Tools, Utilities

Databases

Note that no script that can change the data or the schema of a database should be uploaded here. Use a UNC path to the imsoftech domain instead so that only the intended role players will have access to them. The only exception to this would be the proposed UBdbIntegrityVerifier tool which is guaranteed not to have any side effects that would alter data or it's schema definition.
  1. master
    1. Database Integrity Scripts - These scripts can be safely used to verify the integrity of the master database and are being stored up for use by the proposed UBdbIntegrityVerifier tool
    2. Database Fixup Scripts - These scripts are normally one off scripts to fix a specific situation for a client. We can save them here in case there are needed again or can be adapted for similar situations.
    3. Database Utility Scripts - These utility scripts are designed to perform specific tasks and should be accompanied with instructions on when and how they should be used.
  2. Client database
    1. Database Integrity Scripts - These scripts can be safely used to verify the integrity of the master database and are being stored up for use by the proposed UBdbIntegrityVerifier tool
    2. Database Fixup Scripts - These scripts are normally one off scripts to fix a specific situation for a client. We can save them here in case there are needed again or can be adapted for similar situations.
    3. Database Utility Scripts - These utility scripts are designed to perform specific tasks and should be accompanied with instructions on when and how they should be used.