Data Migration: Database Migration MS SQL to Oracle DB

Data Migration: Database Migration MS SQL to Oracle DB, available at $59.99, has an average rating of 4.45, with 70 lectures, based on 373 reviews, and has 6344 subscribers.

You will learn about 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 This course is ideal for individuals who are Beginner database administrators or Beginner Data Analyst or Anyone who wants learn database migration It is particularly useful for Beginner database administrators or Beginner Data Analyst or Anyone who wants learn database migration.

Enroll now: Data Migration: Database Migration MS SQL to Oracle DB

Summary

Title: Data Migration: Database Migration MS SQL to Oracle DB

Price: $59.99

Average Rating: 4.45

Number of Lectures: 70

Number of Published Lectures: 68

Number of Curriculum Items: 70

Number of Published Curriculum Objects: 68

Original Price: $94.99

Quality Status: approved

Status: Live

What 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

Who Should Attend

Beginner database administrators
Beginner Data Analyst
Anyone who wants learn database migration

Target Audiences

Beginner database administrators
Beginner Data Analyst
Anyone who wants learn database migration

Data Migration is an important function anyone working with a database should be able to carry out.

There are several tools available to perform database and data migration. In this course we will be using a free powerful tool by Oracle called Oracle SQL Developer to migrate a third party database from Microsoft SQL Server into Oracle.

Database migration involves several steps specified below:

Setting up a Migration Repository: The Migrations Repository is a database schema that stores the metadata collected and transformed in the migration process.

Configuring the Third Party Database Connection : You need to configure a database connection for the database which you would like to migrate. There are two steps to this process: Download JDBC driver and Connecting to Third
Party Database.

Capturing Source Database :This step is used to capture a snapshot of the current state of your third-party database and is necessary to provide SQL Developer with a “point in time” view of your database. Once this step is complete, the Migration wizard works on the meta-data stored in its repository, instead of issuing queries against your live database.

Convert Captured Model to Oracle : The next step in the migration process is to convert the captured model of the database to an Oracle-specific model.

Translate Third Party SQL Objects to Oracle :The next step in the migration process is to translate the T-SQL objects – constraints, functions, procedures, triggers, views – to Oracle SQL objects.

Generating Scripts to Create Target Database:Once the conversion process has completed, SQL Developer has a model of what the converted database will look like. This is used to generate SQL scripts for the creation of the new Oracle Database schema(s) and to run these scripts.

Move Data from Third Party Database to Oracle :The last step in the Migration Wizard is to move the data to the new database. Migrating the data is a process that copies the data from the third-party database to the new tables
in the Oracle database. The Migration Wizard uses the same Oracle database connection required to run the scripts as it does to move the data.

We will also be using Microsoft SQL Server Migration Assistant (SSMA) tool to automate database migration to SQL Server

from Oracle, MySQL and Microsoft Access.

Course Curriculum

Chapter 1: Database Setup : Oracle 11g

Lecture 1: Introduction

Lecture 2: Please Note

Lecture 3: Download and install Oracle 11g Express

Lecture 4: Unlock Sample Oracle 11g Express HR Schema

Lecture 5: Download and Install Oracle SQL Developer

Lecture 6: Connect SQL Developer to Oracle 11g

Chapter 2: Oracle 21c Setup

Lecture 1: Download Oracle 21c

Lecture 2: Install Oracle 21c

Lecture 3: Connect to Oracle with SQLPlus

Lecture 4: Connect SQL Developer to Oracle 21c

Lecture 5: Download sample schema

Lecture 6: Unlock sample Schema account

Lecture 7: Unlock sample schema tables

Lecture 8: Connect HR account to Oracle database

Chapter 3: MySQL Database Server Setup

Lecture 1: What is MySQL

Lecture 2: MySQL Download Link

Lecture 3: Install MySQL on Windows

Lecture 4: Install MySQL on Macs

Lecture 5: MySQL Workbench

Lecture 6: Install MySQL Workbench on Macs

Lecture 7: MySQL Data Types

Chapter 4: Microsoft SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server Editions

Lecture 3: Download SQL Server

Lecture 4: Install SQL Server

Lecture 5: SQL Server Configuration Manager

Lecture 6: Install SQL Server Management Studio

Lecture 7: Connect SSMS to SQL Server

Lecture 8: Restore sample database

Chapter 5: Database Migration: Oracle to SQL Server

Lecture 1: Install SSMA for Oracle

Lecture 2: Create a new SSMA project

Lecture 3: Connect to Oracle Database Server

Lecture 4: Connect to SQL Server

Lecture 5: Create pre-migration assessment report

Lecture 6: Map Oracle database schema to SQL Server

Lecture 7: Convert Oracle schema to SQL Server

Lecture 8: Load converted database objects into SQL Server

Lecture 9: Migrate data to SQL server

Lecture 10: Post migration test

Chapter 6: Microsoft Access Setup

Lecture 1: What is Microsoft Access

Lecture 2: How to get Microsoft Access

Lecture 3: Install sample database

Chapter 7: Migrating from Microsoft SQL Server to Oracle

Lecture 1: Creating database user

Lecture 2: Creating repository

Lecture 3: Configuring third party database connection – part 1

Lecture 4: Configuring third party database connection – part 2

Lecture 5: Capturing source data

Lecture 6: Converting Captured Model to Oracle

Lecture 7: Translating Third Party T-SQL objects to Oracle

Lecture 8: Generating scripts to create target database

Lecture 9: Moving Data from SQL Server into Oracle

Chapter 8: Database Migration: MySQL to SQL Server

Lecture 1: Install SSMA

Lecture 2: Prerequisites

Lecture 3: SQL Server Agent

Lecture 4: Pre-migration assessment

Lecture 5: Validating type mappings

Lecture 6: Converting schema

Lecture 7: Performing the migration

Lecture 8: Post migration data validation

Chapter 9: Database Migration: Access to SQL Server

Lecture 1: Backup Access database

Lecture 2: Install SQL Server Migration Assistant for Access

Lecture 3: Create a new SSMS Project

Lecture 4: Create pre-migration assessment report

Lecture 5: Create a new database

Lecture 6: Convert access schema

Lecture 7: Migrate Access Database to SQL Server

Lecture 8: Post Migration Checks

Lecture 9: Thank You

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 3 votes
2 stars: 9 votes
3 stars: 48 votes
4 stars: 173 votes
5 stars: 140 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu