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

This report provides a detailed system analysis and design for migrating from Microsoft Access to MS SQL Server Database. It includes steps for migration, screenshots, and test results.

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.

3SYSTEM ANALYSIS AND DESIGN
5. On the next step, user ID and password need to be set to prevent any unauthorized access.
6. Analyze perform data testing and generate database report.
Screenshots: The screenshots of the data migration using upsizing wizard tool is provided. The
test has been conducted for an arbitrary database.
Figure 1: chose the SQL SERVER

4SYSTEM ANALYSIS AND DESIGN
Figure 2: In case of new database, server needs to select.
Figure 3: Identify the attributes and tables from Microsoft access to migrate into SQL
server.

5SYSTEM ANALYSIS AND DESIGN
Figure 5: open SQL server and open migrated database

6SYSTEM ANALYSIS AND DESIGN
Figure 6: Migration Result
Figure 7: Uprising Report analyzing report

7SYSTEM ANALYSIS AND DESIGN
Once the migration has been completed, the database functionalities must be test
efficiently. The new database in the SQL server needs to check according to the functionality.
Further, the administrators can check specific tables to confirm the successfulness. Finally,
upsized parameters can be set including attributes, tables and relation. Migration log is also
generated and attached below
Conclusion:
The above report showcase migration test from Microsoft access to MS SQL server
database. The detail steps to compete the migration are illustrated with suitable screenshots. The
migration process using uprising wizard is described along with the test results. The migration
process must be conducted while following and ensuring certain steps. For instance, before start
migrating some pre-requisite step also needs to be conducted. After the migration, the new
database in the SQL server needs to check according to the functionality. Further, the
administrators can check specific tables to confirm the migration.

8SYSTEM ANALYSIS AND DESIGN
References:
Zhao, G., Lin, Q., Li, L. and Li, Z., 2014, November. Schema conversion model of SQL
database to NoSQL. In P2P, Parallel, Grid, Cloud and Internet Computing (3PGCIC), 2014
Ninth International Conference on (pp. 355-362). IEEE.