Data Migration: Database Migration MS SQL to Oracle DB
4.3 (148 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,123 students enrolled

Data Migration: Database Migration MS SQL to Oracle DB

Practical Hands-on Migrating from Microsoft SQL Server to Oracle
4.3 (148 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,123 students enrolled
Last updated 2/2018
English
English [Auto]
Current price: $79.99 Original price: $114.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 1.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll 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
Course content
Expand all 16 lectures 01:35:56
+ Database Setup
7 lectures 45:35
Download and Install Oracle SQL Developer
08:55
Connect SQL Developer to Oracle
06:05
Download SQL Server
08:22
Download and attach sample database
07:12
+ Migrating from Microsoft SQL Server to Oracle
9 lectures 50:21
Creating database user
03:53
Creating repository
02:35
Configuring third party database connection - part 1
06:28
Configuring third party database connection - part 2
07:25
Capturing source data
07:36
Converting Captured Model to Oracle
01:57
Translating Third Party T-SQL objects to Oracle
10:11
Generating scripts to create target database
02:21
Moving Data from SQL Server into Oracle
07:55
Requirements
  • You should be able to use a PC at beginner level
  • You should have some basic understanding of SQL
  • You should some basic understanding of database systems
Description

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

Who this course is for:
  • Beginner database administrators
  • Beginner Data Analyst
  • Anyone who wants learn database migration