Sydney Dentist Centre DB Upgrading - Migration and Testing Plan

Running head: SYDNEY DENTIST CENTRE DB UPGRADING
Sydney Dentist Centre DB upgrading
Name of the student:
Name of the University:
Author note:

1
SYDNEY DENTIST CENTRE DB UPGRADING
Table of Contents
Introduction................................................................................................................................2
Migration and Test Plan.............................................................................................................2
Upsizing Wizard.....................................................................................................................2
Before starting with the migration.....................................................................................2
The Steps for migration......................................................................................................3
Testing and Test analysis...................................................................................................3
Screenshots.........................................................................................................................4
Conclusion..................................................................................................................................6

2
SYDNEY DENTIST CENTRE DB UPGRADING
Introduction
The Sydney Dentist Centre is aiming at developing an integrated system that will
have a well-structured database system using SQL Server. Currently, they have their database
on a Microsoft Access platform, which they plan to migrate and test before they fully deploy
the system. This will provide them with all varied information about the centre database. In
this report, the migration plan for existing database will be explained and details about testing
the following system will be discussed. The test plan will include a critical analysis of a
common Microsoft tool that is available for this task.
Migration and Test Plan
Microsoft has quite a handful of tools and strategies that can be used in order to
convert or import a complete MS Access database into MS SQL Server. Below, the Upsizing
Wizard tool will recommended for this purpose and its technical details will be considered to
perform the migration testing.
Upsizing Wizard
Upsizing is a technique within Microsoft that allows the safe migration of data from
an Access database into a SQL Server database. It provides high performance, scalability and
enhanced security features (Aspin 2012).
Before starting with the migration
However, before the process can be started, a few crucial steps must be taken. These
include the advance backup of the Access data that is being migrated. This will avoid the risk
of the data being lost in case of a system failure. Unique indexes must also be created
beforehand for the ease of upsizing. Also, all adequate SQL Server permissions must be
granted.