Database Migration is defined as the process of translating data from one format to another when the organization decides to use a new computing system or a new database management system that is incompatible with the current system.
Databases are now a very essential part of many organizations. They form integral units for storage and collection of data. However the problem arises when existing systems become unusable or a higher version of database is required to meet rising system compatibility. Manually transferring data is a tedious scheme as the size of the data present usually borders from a few megabytes to a few hundred terabytes. Also when a human element is involved,the probability of errors occurring is much higher. Therefore the need for a tool to successfully migrate the data is required. Database Migration is defined as the process of translating data from one format to another when the organization decides to use a new computing system or a new database management system that is incompatible with the current system. The Database Migration is markedly different from data movement. This is because data movement involves only movement of data. Database migration on the other hand involves transfer of data along with some change in the application. The Database Migration tool acts as an interface between the two databases and the user. It creates a new database on the destination database type i.e. MS SQL 2005 similar to the source database present on MySQL 5.0. The schema of the two databases has to be almost alike. But the features offered by the two databases differ from each other in many ways. Thus some manipulations and adjustments are required to be made by the tool so as to maintain the overall structure and functionality of the database. Thus the schema may vary at certain areas. The tool thus implements various mapping function to derive equivalent data types in MS SQL Server while creating the tables. Then the constraints placed on these tables have to be replicated as it is on the destination database system. This is followed by migration of other complex objects like the views, procedures, triggers and functions. This requires some highly specialized functions or parsers which can convert the definitions of these objects from MySQL syntax to the MS SQL syntax. The final step in migration is the transfer of the data from one database to another. Database migration is a complex process and is usually avoided until there is no other viable option. This is because databases are usually huge and are complex. Many triggers, stored procedures and functions exist which may require a competent and efficient parser for their migration. Often many issues crop up, which require personal attention of a user having technical knowledge of the databases. Main Migration Steps:
- Decide how you will map MySQL databases to SQL Server 2005.
- Convert database objects; these are tables, tables constraints, views, procedures, functions,and triggers.
- Map data types from the MySQL data type to a SQL Server data type.
- Rewrite your views, procedures, and functions according to SQL Server syntax.
Assumptions are not defined for this project.
Duration is not defined for this project.
References are not defined for this project.