1 / 24

SQL Server Migration Planning Guide for Oracle Users

This comprehensive guide provides a complete strategy and implementation plan for migrating from Oracle to SQL Server 2008 R2. It covers engagement overview, customer considerations, daily breakout activities, deliverables, and more to ensure a successful migration process.

oralee
Download Presentation

SQL Server Migration Planning Guide for Oracle Users

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Server Deployment Planning ServicesMigrating to SQL Server 2008 R2 from OracleSTRATEGY IMPLEMENTATION GUIDE

  2. Agenda • Engagement Overview • Customer Considerations • Definitions • Daily Breakout

  3. Migration Engagement Overview Key activities by assessment type/length • Objectives • Deliver value each week preparing for SQL Server migration 5 Day Offer 10 Day Offer 15 Day Offer • Help Customer Prioritize candidate databases (DB) • Gather application and SSMA data for DBs • Deliverables • DB Analysis reports & complexity ratings • Full SSMA evaluation & Light Assessment(2 DBs) • Application Assessment for DB • Deep Analysis (1 DB) • Deliverables • Analysis Results & scope/effort (1 DB) • SQL infrastructure Planning • Migration Planning • Deliverables • Scope of effort for DB, Full Migration Plan & Server Infrastructure

  4. Assessment Outcomes Deliverables and goals by type of assessment Target Customers: SQL Server customers planning to migrate from Oracle.

  5. Migration Engagement Overview Key elements, activities, and deliverables • 1 • 2 • 3 • What’s Provided • What the Partner Does • What’s Delivered BOM Deliverables • Surveys • Templates • Resources Surveys DB Ranking/SSMA • Gather Information Light Assessments Detailed Assessment on selected DB • Analyze Data Migration Plan Server Architecture Plan • Develop Application Migration plan

  6. Target Customer Considerations Assure that these considerations are met The target customer should: • Own SQL Server 2008 R2 Licenses • Have Software Assurance points available to use for Deployment Planning Services • Have Oracle DBs/Applications they are considering moving to the SQL Platform • See the value in moving to SQL Server as a cost effective platform for their database server requirements • Enable the SSDPS partner to access relevant data for project success

  7. Customer Actions Required Customers must complete surveys and participate at key milestones • Completed Pre-Engagement Questionnaire • MAPS as appropriate if more detail needed from customer prior to DB survey completion • Participate in kickoff and closure meetings • Participate/ provide approval in week 2 DB selection • Participate in Customer Satisfaction Surveys

  8. Light and Detailed Assessments Definitions to clarify the differences Light Assessment Detailed Assessment • Less rigorous assessment process including • Review of SSMA/survey reports to stack rank DBs and validate labor estimates provided by tool. • Rank by least effort to most effort for evaluation purposes • Rationalize tool estimates • Can consume 3-15 hours • Conduct a more rigorous assessment process to resolve migration issues including • Application conversion • Integration • Data migration • Tuning • Testing • Adherence to any customer IT management policy for the SQL Server Solution • Time intensive, should really only be performed on one DB to maintain 15 day goal

  9. Pre-Engagement Readiness Process and assumptions Process • Customer preparation work completed • Database Candidates shortlist • MS Assessment & Planning toolkit (as required) • Pre-engagement asks • Surveys distributed ahead of engagement start • Kickoff meeting objectives and customer preparation Assumptions • Consultant Laptops have (Oracle and SQL Server) • Completed Surveys & DDL available from client at Kickoff • SSMA Tool Knowledge

  10. Pre-Engagement Tools Complete surveys and MAPs using these tools

  11. Assessment Offerings Detailed Activities Weekly and daily breakouts

  12. Week 1 Overview Key activities, tools, and deliverables Close week with the following deliverables • DB Evaluation and ranking for Week 2 • Plan for Week Two

  13. Day 1 Kickoff and other key activities • Kickoff meeting • Collection of DDL for targeted DBs • Build-out of DB schema on Oracle • Collection of Survey results for targeted DBs • Commencement of SSMA tool on databases • Number of DDLs provided in first selection may impact this activity’s start

  14. Day 2 and Day 3 Key activities • Completion of DB creation • Continuation of SSMA evaluations • Collect SSMA Reports from tool • SSMA work continuation • As required • Status report preparation • Status update on SSMA progress • Survey and SSMA report matching • Need document with both results • Dependent on number of DBs and Reports

  15. Day 4 and Day 5 Report consolidation and presentation • Finish report consolidation • Preparation for Friday meeting • Report preparation • Create analysis plan for next week • Distribute Customer Survey as required • Finalize plan for 2nd week • Finalize and present report • Present data regarding reports • Week One PPT presentation template • Conduct 1st Week’s summary & acceptance meeting

  16. Week 2 Overview Key activities, tools, and deliverables Close week with Targeted DB and rough scope-of-effort deliverables

  17. Day 6 and Day 7 Kickoff and begin assessments • Weekly Kickoff • Initiate light assessments of selected DBs • Can consume 5 hours per DB • Identification of Selected DB for Deep Assessment

  18. Day 8 Checkpoint for detailed assessment • Recommendation for Detailed Assessment • Prepare for meeting • Hold business value meeting to propose/agree on target DB for Detailed Assessment • Request application code (as appropriate) for target DB • Commence deep assessment on selected DB

  19. Day 9 and Day 10 Assessments and Closure • Detailed assessment Target DB cont. • Scope of effort to resolve issues such as • Migration, Application & Script conversion • Potential third party integration issues • Deliverables Preparation • Presentation • Target DB scope of effort report • Weekly closure meeting • Presentation of deliverables

  20. Day 10 Weekly closure activities • Detailed evaluation continued (as necessary) • Deliverables Preparation • Presentation • Target DB scope of effort report • Weekly closure meeting • Presentation • Deliverables and acceptance

  21. Week 3 Overview Key activities, tools, and deliverables Close week with the following deliverables • Full Scope of application /DB effort to migrate • Migration plan for Target DB • SQL infrastructure plan

  22. Day 11 Kickoff the week • Preparation for Kickoff • Weekly kickoff • Commence application Code analysis • As Required • Commence SQL & Migration Planning • As Required

  23. Day 12 Through Day 14 Plan creation for migration and infrastructure • Develop detailed Migration plan for target DB • Develop SQL architecture plan • Server sizing, configuration & conformance to Customer IT management toolset • Meeting Prep for Friday • Presentation of migration plan • Presentation of SQL configuration • Presentation of scope of effort to move target DB to production

  24. Day 15 Finalize plans and closure • Finish Planning • Meeting Preparation • Acceptance meeting/Presentation of deliverables • Fully scoped effort to migrate target DB • Migration plan for target DB • SQL architecture plan • Distribute Customer Satisfaction Survey

More Related