Learn Data Migration: Database Migration MS SQL to Oracle DB

Description

In this course, you will learn :

• Migrate SQL Database to Oracle
• Connect to third party database
• Capture third party source data
• Configure third party database connection
• Convert Captured Data Model to Oracle
• Create Migration Repository
• Generate Migration Scripts to create Target Database
• Translate Third Party SQL Objects to Oracle
• Move Data from SQL Server into Oracle

Syllabus :

1. Database Setup

• Download and install Oracle
• Unlock Sample Oracle HR Schema
• Download and Install Oracle SQL Developer
• Connect SQL Developer to Oracle
• Download SQL Server
• Download and attach sample database

 

2. Migrating from Microsoft SQL Server to Oracle

• Creating database user
• Creating repository
• Configuring third party database connection
• Capturing source data
• Converting Captured Model to Oracle
• Translating Third Party T-SQL objects to Oracle
• Generating scripts to create target database
• Moving Data from SQL Server into Oracle

Show more