Migration Project for Oracle 11G to MYSQL Server

Database migration is a process of moving the data from one platform to other platform based on its features for a better utilization of the data in an easier way. Migration project is basically moving the data and the structure from Oracle 11G to MSSQL Server 2014 by using Informatica mappings/workflows that apply changes to which are going to effect because of the above migration. The new mappings should point to the new SQL Server. The existing Oracle 11G database will be replaced by MSSQL Server 2014 database. The work involved is:  Understanding the existing database objects like tables, functions, procedures, packages etc. and also create the same in the MSSQL Server 2014 database.  Move the existing data from Oracle database to the MSSQL Server 2014 database.  Test the data which is migrated successfully, if not make the necessary corrections to bring all the data in the required format.  Migrate the existing mappings to point to the MSSQL Server 2014 database which are currently pointing to Oracle Database.  Test all the mappings that are valid and working fine in the new environment, if not make the necessary corrections.  Comparing the migrated records from the records that are generated by the final destination system and that the transferred or moved records are complete and are appropriate to the point.  Summary Verification is a technique, but there are various other techniques that provide a complete summary about record count and checksums, the number of records that are migrated is compiled from the destination and then compared to the records that are migrated.  Compare migrated records to the Sources (Sampling) where the tests should verify that fields and the values which are migrated as per the specification. In short, the values and the field level mappings all are used to calculate the required results at the final destination point.  Table structure and Columns are matched between Oracle and SQL Server.  Data Count Validation is done between Oracle and SQL Server.  Data Comparison between Oracle and SQL Server is performed once the Data migration is finished.  Functional Testing on migrated data is performed, once the comparison done.