DB Migration Project (MS SQL Server 2008 R2 to ORACLE 11 G )
1. Source Database - Microsoft SQL Server 2008 R2
2. Target Database - Oracle 11g
3. Coverage of Migration:
3.1. Existing data tables ( Not issue as SQL developer is used to migrate data successfully)
3.2. Procedures - There are 50 to 60 procedures written specific to the product design and same need to be migrated on target DB. One of the most complex Procedure attached below for reference.
3.3. Functions - MS SQL based 40 to 50 functions are written and same need to be in Target DB environment.
3.4. Triggers - same as point 3.3
4. Post migration 3 to 5 days remote support needed for technical team to test all product functionality.
5. Timeline - Above migration is Project based engagement and resource and time is to be estimated but not on T&M basis to be charged. Cost will be Fixed cost with fixed calender days to complete.
Includes Support cost for 1 week.
Skills: design, test, microsoft-sql-server