Database Setup for UAT using SQL Server 7.0

This topic explains how to run the scripts required to setup the Image (osImage) and Patient (ukctocs) databases required by the URA System using SQL Server 7.0.

Follow these steps using Enterprise Manager. You will find the scripts in the program's installation directory within the DbScripts subdirectory

  1. Remove any pre-existing osImage database and any URA Stored Procedures on ukctocs

  2. Logon to your database as a System Administrator (sa)

  3. Create a login for URAAdmin

  4. Login as URAAdmin

  5. Create the osImage database - accept defaults

  6. Create the ukctocs database (if not already created)

  7. Run the script CreateImageDbTablesSQL7.sql

  8. Run the script CreateImageDbStoredProcsSQL7.sql

  9. Run the script CreatePatientDbTablesSQL7.sql (if not using an existing ukctocs database)

  10. Run the script CreatePatientDbStoredProcsSQL7.sql

  11. Run the script PopulatePatientTablesSQL7.sql (remove these records at the end of the UAT by running CleanPatientTablesSQL7.sql)

  12. Create the following logins

  13. Grant execute permissions to all users - see Stored Proc List

  14. Prepare the program's config file

  15. Run UAT

  16. Run the script CleanPatientTablesSQL7.sql

  17. Prepare for move into production