We have a project to upgrade the existing MS SQL Server 2000 to MS SQL Server 2005. As this project activity is running in parallel with the change requests for August deployment we need to ensure the servers required for the deployment does not impact the tight timelines for the deliverable.
The implementation strategy for August deployment are:
- Database server upgrade and migration to test environment. This is to be done before deploying new codes to the test environment for user acceptance testing.
- System Integration Testing – Data Integrity Testing
- Deployment the new codes to test server for IT and User acceptance testing.
- User Acceptance Testing – Functionality testing.
- Database server upgrade and migration to Production environment. This is done after obtaining the user sign-off from the UAT that the application and newly upgrade database server are working as business as usual (BAU).
- Update the user guides and training for the end users.
In this way, we have worked out the dependencies and outline the implementations that both activites run in parallet and minimize any project schedule’s timelines.
Advertisements
0 Responses to “Database Server Upgrade Implementation”