slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
SQL Server Deployment Planning Services Migrating to SQL Server 2008 R2 from Oracle STRATEGY IMPLEMENTATION GUIDE PowerPoint Presentation
Download Presentation
SQL Server Deployment Planning Services Migrating to SQL Server 2008 R2 from Oracle STRATEGY IMPLEMENTATION GUIDE

Loading in 2 Seconds...

play fullscreen
1 / 24

SQL Server Deployment Planning Services Migrating to SQL Server 2008 R2 from Oracle STRATEGY IMPLEMENTATION GUIDE - PowerPoint PPT Presentation


  • 94 Views
  • Uploaded on

SQL Server Deployment Planning Services Migrating to SQL Server 2008 R2 from Oracle STRATEGY IMPLEMENTATION GUIDE. Agenda. Engagement Overview Customer Considerations Definitions Daily Breakout. Migration Engagement Overview. Key activities by assessment type/length. Objectives

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SQL Server Deployment Planning Services Migrating to SQL Server 2008 R2 from Oracle STRATEGY IMPLEMENTATION GUIDE' - tavon


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
slide1

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

agenda
Agenda
  • Engagement Overview
  • Customer Considerations
  • Definitions
  • Daily Breakout
migration engagement overview
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
assessment outcomes
Assessment Outcomes

Deliverables and goals by type of assessment

Target Customers: SQL Server customers planning to migrate from Oracle.

migration engagement overview1
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
target customer considerations
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
customer actions required
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
light and detailed assessments
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
pre engagement readiness
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
pre engagement tools
Pre-Engagement Tools

Complete surveys and MAPs using these tools

week 1 overview
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
day 1
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
day 2 and day 3
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
day 4 and day 5
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
week 2 overview
Week 2 Overview

Key activities, tools, and deliverables

Close week with Targeted DB and rough scope-of-effort deliverables

day 6 and day 7
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
day 8
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
day 9 and day 10
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
day 10
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
week 3 overview
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
day 11
Day 11

Kickoff the week

  • Preparation for Kickoff
  • Weekly kickoff
  • Commence application Code analysis
    • As Required
  • Commence SQL & Migration Planning
    • As Required
day 12 through day 14
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
day 15
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