Migrating Oracle Databases to SQL Server (OracleToSQL)

Migrating Oracle Databases to SQL Server (OracleToSQL), available at $29.99, has an average rating of 4.55, with 30 lectures, based on 20 reviews, and has 1490 subscribers.

You will learn about Migrate Oracle Database Objects to SQL Server Objects Map Oracle Database schemas to SQL Server Database Objects Convert Oracle database schema into SQL Server schemas Load converted Oracle database objects into SQL Server Migrate Oracle data into SQL Server Perform Post Migration Test This course is ideal for individuals who are Beginners to Data Migration or Beginners to Database Migration It is particularly useful for Beginners to Data Migration or Beginners to Database Migration.

Enroll now: Migrating Oracle Databases to SQL Server (OracleToSQL)

Summary

Title: Migrating Oracle Databases to SQL Server (OracleToSQL)

Price: $29.99

Average Rating: 4.55

Number of Lectures: 30

Number of Published Lectures: 30

Number of Curriculum Items: 30

Number of Published Curriculum Objects: 30

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Migrate Oracle Database Objects to SQL Server Objects
Map Oracle Database schemas to SQL Server Database Objects
Convert Oracle database schema into SQL Server schemas
Load converted Oracle database objects into SQL Server
Migrate Oracle data into SQL Server
Perform Post Migration Test

Who Should Attend

Beginners to Data Migration
Beginners to Database Migration

Target Audiences

Beginners to Data Migration
Beginners to Database Migration

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation. It is a database commonly used for running online transaction processing, data warehousing and mixed database workloads.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

Oracle and SQL Server are both very popular RDBMS systems that are widely used to run enterprise applications.

SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server, Azure SQL Database, or Azure Synapse Analytics, and then migrate data to SQL Server, Azure SQL Database, or Azure Synapse Analytics. Note that you cannot migrate SYS and SYSTEM Oracle schemas.

These days lot of customers are looking to save on their technology costs. Adopting economical technologies and software that are equally capable and powerful to fulfil requirements is one of the ways to achieve cost optimization.

Databases are one of the tiers which customers spend a lot of money as part of license and support fees. Support staff is an additional cost to maintain these databases. SQL Server is very economical if we compare it with Oracle and that is the main reason for clients to choose SQL Server over Oracle.

Course Curriculum

Chapter 1: Oracle Setup

Lecture 1: Introduction

Lecture 2: Oracle Installation Requirements

Lecture 3: Download Oracle

Lecture 4: Install Oracle

Lecture 5: Connect to Oracle with SQLPlus

Lecture 6: How to start and stop Oracle

Lecture 7: What is SQL Developer

Lecture 8: Download SQL Developer

Lecture 9: Connect SQL Developer to Oracle

Lecture 10: Download Sample Schema

Lecture 11: Unlock sample schema account

Lecture 12: Unlock sample schema tables

Lecture 13: Connect sample Schema account to Oracle

Lecture 14: What is TNS Names

Lecture 15: Creating TNS Names

Lecture 16: Connect to Oracle with TNS Names

Chapter 2: SQL Server Setup

Lecture 1: Download SQL Server

Lecture 2: Install SQL Server

Lecture 3: Install SQL Server Management Studio -SSMA

Lecture 4: Connect SSMS to SQL Server

Chapter 3: Migrating Oracle Database to SQL Server

Lecture 1: Install SSMA for Oracle

Lecture 2: Creating a new SSMA Project

Lecture 3: Connect to the Oracle database server.

Lecture 4: Connect to an instance of SQL Server.

Lecture 5: Create pre-migration assessment reports

Lecture 6: Map Oracle database schemas to SQL Server database schemas.

Lecture 7: Convert Oracle database schemas into SQL Server schemas.

Lecture 8: Load the converted database objects into SQL Server.

Lecture 9: Migrate data to SQL Server.

Lecture 10: Post Migration Test

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 7 votes
5 stars: 11 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