Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Software Development Tools No-Code Development
Business
Entrepreneurship Communication Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certifications Network & Security Hardware Operating Systems & Servers Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Paid Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement & Gardening Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition & Diet Yoga Mental Health Martial Arts & Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Learning Teacher Training Test Prep Other Teaching & Academics
Web Development JavaScript React Angular CSS Node.Js Typescript HTML5 PHP
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Amazon AWS Cisco CCNA CompTIA Security+ Microsoft AZ-900
Microsoft Power BI SQL Tableau Data Modeling Business Analysis Data Analysis Data Warehouse Blockchain Business Intelligence
Unity Unreal Engine Game Development Fundamentals C# 3D Game Development C++ Unreal Engine Blueprints 2D Game Development Mobile Game Development
Google Flutter iOS Development Android Development Swift React Native Dart (programming language) Kotlin SwiftUI Mobile App Development
Graphic Design Photoshop Adobe Illustrator Drawing Canva Digital Painting InDesign Design Theory Procreate Digital Illustration App
Life Coach Training Neuro-Linguistic Programming Personal Development Personal Transformation Life Purpose Mindfulness Sound Therapy Emotional Intelligence Coaching
Business Fundamentals Entrepreneurship Fundamentals Freelancing Business Strategy Online Business Startup Business Plan Blogging Amazon Kindle Direct Publishing (KDP)
Digital Marketing Social Media Marketing Marketing Strategy Internet Marketing Copywriting Google Analytics Email Marketing Startup Advertising Strategy

DevelopmentDatabase Design & DevelopmentOracle SQL

Data Migration: Database Migration MS SQL to Oracle DB

Practical Hands-on Migrating from Microsoft SQL Server to Oracle
Rating: 4.3 out of 54.3 (334 ratings)
6,142 students
Created by Bluelime Learning Solutions
Last updated 6/2021
English
English [Auto]

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

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

Instructor

Bluelime Learning Solutions
Learning made simple
Bluelime Learning Solutions
  • 4.1 Instructor Rating
  • 34,449 Reviews
  • 735,083 Students
  • 418 Courses

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.

Top companies choose Udemy Business to build in-demand career skills.
NasdaqVolkswagenBoxNetAppEventbrite
  • Udemy Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Investors
  • Terms
  • Privacy policy
  • Sitemap
  • Accessibility statement
Udemy
© 2022 Udemy, Inc.