Overview

Background

IS Applications are now undertaking a series of projects to migrate existing databases from our old database infrastructure to the new one established under project ITS100. The reasons for the moves are well known, with the old environment approaching the end of its lifespan, and the various benefits of improved peformance and greater reliabilty being offered by the new infrastructure, as well as the potential of better failover capabilities. This project covers the migration of the CARS database (in DEV, TEST & LIVE) to the new infrastructure. This is the database for the Careers applications - SAGE & SAGE Admin, and Careers Tracking (CSSGT).

Scope, Objectives and Deliverables

The scope of this project includes the following:

1. Establishing the parameters of what needs to be done for the migrations using the guidance available here
2. Setting up versions of the CARS database in DEV, TEST and LIVE that will replace those on the old infrastructure
3. Undertaking any relevant testing on the DEV version
4. Carrying out user testing on the TEST version to ensure the test versions of the related applications can access the migrated database
5. Resolving any problems reported during user testing
6. Deploying the migrated version to LIVE
7. Updating the TAD and any other relevant documentation

No changes that would affect the functionality of the database or related applications will be made. The decommissioning of older versions of migrated databases has not been included in the scope of migration projects so far but should be considered as far as possible, within the time & cost limits of the project.

The objectives are as follows:

1. To migrate the DEV, TEST & LIVE versions of the CARS database to the new database infrastructure
2. To update supporting technical documentation for the migrated databases & related applications

The deliverables for the project are:

1. A migrated version of the CARS database in DEV, TEST and LIVE
2. Updated technical and support documentation

Benefits

1. Increased reliability
2. Reduced support time
3. Reduced loss of service
4. Improved customer service

Success Criteria

The success of the project will be determined by the achievement (or not) of the above objectives.