System Analysis and Design for Migration from Microsoft Access to MS SQL Server Database

Running head: SYSTEM ANALYSIS AND DESIGN
SYSTEM ANALYSIS AND DESIGN
Name of the Student
Name of the University
Author Note

1SYSTEM ANALYSIS AND DESIGN
Table of Contents
Introduction:....................................................................................................................................2
Upsizing Wizard:.............................................................................................................................2
Migration.........................................................................................................................................2
Step for Migration............................................................................................................................2
Screenshots:.....................................................................................................................................3

2SYSTEM ANALYSIS AND DESIGN
Introduction:
Sydney dentist center want to replace their old existing system which was developed in 2005.
Even though, the database requirement and design of the both system is similar. The new system
will enable more secure and optimized data management. They were previously using Microsoft
access database to store patient information and want to migrate their infrastructure to Microsoft
SQL servers. The main reason for this decision is that they want integrated support with all the
center database information. The IT staff at SDLC plan to migrate existing data into new system.
The report will elaborate the migration plan and test analysis will be conducted with a critical
analysis of Microsoft SQL that is available for this task.
Upsizing Wizard: Upsizing is often used to safely migrate data from an access database into a
Microsoft sql server database. Upsizing is a technique that offers enhanced security features
along with Scalability and high performance (Zhao et al. 2014).
Migration
Microsoft provides several useful strategies and tools which can be utilized to import and convert
MS Access database to SQL Server database. For performing migration testing, upsizing Wizard
tool can be used to convert the database.
Step for Migration
For migrate the database `
1. Identify the dataset which will be migrated to MS SQL Server database.
2. Tables which are contains in the MS Access database need to be upsized.
3. Then attributes of the upsized need to be mentioned properly.
4. Now, two database needs to be linked by following available ways to upsize the existing
database to MS SQL server.