Migrating Oracle Databases to SQL Server (OracleToSQL)

Focused View

Bluelime Learning Solutions

1:55:59

7 View

1. Oracle Setup

1. Introduction.mp4

00:20

2. Oracle Installation Requirements.mp4

01:27

3. Download Oracle.mp4

03:59

4. Install Oracle.mp4

01:58

5. Connect to Oracle with SQLPlus.mp4

03:13

6. How to start and stop Oracle.mp4

01:26

7. What is SQL Developer.mp4

02:41

8. Download SQL Developer.mp4

03:41

9. Connect SQL Developer to Oracle.mp4

02:29

10. Download Sample Schema.mp4

02:12

11. Unlock sample schema account.mp4

05:18

12. Unlock sample schema tables.mp4

04:39

13. Connect sample Schema account to Oracle.mp4

01:49

14. What is TNS Names.mp4

04:09

15. Creating TNS Names.mp4

06:43

16. Connect to Oracle with TNS Names.mp4

03:20

2. SQL Server Setup

1. Download SQL Server.mp4

04:31

2. Install SQL Server.mp4

09:43

3. Install SQL Server Management Studio -SSMA.mp4

05:48

4. Connect SSMS to SQL Server.mp4

07:46

3. Migrating Oracle Database to SQL Server

1. Install SSMA for Oracle.mp4

06:55

2. Creating a new SSMA Project.mp4

01:14

3. Connect to the Oracle database server..mp4

02:46

4. Connect to an instance of SQL Server..mp4

02:35

5. Create pre-migration assessment reports.mp4

05:40

6. Map Oracle database schemas to SQL Server database schemas..mp4

05:04

7. Convert Oracle database schemas into SQL Server schemas..mp4

02:22

8. Load the converted database objects into SQL Server..mp4

04:59

9. Migrate data to SQL Server..mp4

04:00

10. Post Migration Test.mp4

03:12

Description

Migrate Oracle Databases to SQL Server step by step

What You'll 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 is this for?

Beginners to Data Migration

Beginners to Database Migration

What You Need to Know?

You must have SQL Server Migration Assistant installed. (The course shows you how)

You must have Oracle Installed

You must have SQL Server Database Installed

More details

Description
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.

Who this course is for:
Beginners to Data Migration
Beginners to Database Migration

User Reviews

Rating

average 0

Total votes0

Focused display

Bluelime is UK based and creates quality easy to understand eLearning solutions .All our courses are 100% video based. We teach hands –on- examples that teach real life skills .Bluelime has engaged in various types of projects for fortune 500 companies and understands what is required to prepare students with the relevant skills they need.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.