ORACLE TO SQL SERVER MIGRATION

 

 

 

 

MANAGING AN ORACLE TO SQL SERVER MIGRATION

Onomi are a leading independent multi-platform Database Specialist providing a range of consulting services that can help you manage an Oracle to SQL Server migration. Our senior consultants hold both Oracle and SQL Server accreditation’s providing our clients with valuable experience to manage and deliver cross platform migration projects.

 

Our Core skills

Moving From:

  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12C

 

  Moving To:

  • SQL Azure / Data Factory
  • SQL Server 2017
  • SQL Server 2016
  • SQL Server 2014
  • SQL Server 2012
  • SQL Server 2008 r2

 

 

 

 

Supporting the full project lifecycle Onomi can provide a range of service to compliment the client’s skills and resources including: Discovery & Design, Provisioning, Data Migration, Testing, Training and on-going Managed Services.

The areas typically covered during an Oracle to SQL Server migration include:

 

  • Review Application Tier Integration
  • Review Messaging Tier Integration
  • Prod Physical Infrastructure Sizing
  • SQL Server Architecture Design
  • Install Test Environment
  • TEST: Conversion, Creation &/or Migration of:
    • Schemas
    • Security Items
    • Tables
    • LOB’s
    • System Functions
    • System Packages
    • Database & Materialised Views
    • Stored Procedures & Packages
    • User Defined Functions
    • Triggers
    • Sequences
    • Synonyms
    • Data Types
  • Review SQL > PL/SQL changes with development team
  • SQL Server Best Practice Installation
  • TEST: Data Migration
  • TEST: Issue Remediation
  • Functional Testing (regression)
  • Non Functional Testing (Perf, Security)
  • PROD: Object & Data Migration (trial)
  • PROD: Reset Environment
  • Service Transition (live PROD imps)
  • Go Live

Work with Onomi to transition from Oracle to SQL Server and start to see the benefits sooner.

Share This