Skip to content

Instantly share code, notes, and snippets.

@dougwaldron

dougwaldron/Oracle-to-SQL-Server.md

Created May 19, 2020 13:58
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save dougwaldron/4db5b8ff7fa23a6512df510ac533ebe6 to your computer and use it in GitHub Desktop.
Save dougwaldron/4db5b8ff7fa23a6512df510ac533ebe6 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle to SQL Server Migration Plan
Raw
Oracle-to-SQL-Server.md

Oracle to SQL Server Migration Plan

Documentation

  • Business processes
  • Codebase
  • Database
  • Data flows

Infrastructure

  • Server setup/configuration
  • Dev/UAT/Prod environments
  • Users/permissions

Database tasks

  • Identify and remove unneeded objects
  • Migrate table structure
  • Data type mapping
  • Migrate data
  • Migrate programming
    • Procedures/Packages
    • Views
    • Triggers
    • Schedules
    • Java

Data flows

  • Staging table/schema migration
  • Local procedures/schedules
  • Configure VESA services

Codebase

  • Database connections
  • DAL programming
  • Embedded SQL statements
  • Data types
  • Crystal Reports

Deployment

  • Testing
  • Documentation of deployment process
  • Execution
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment