Categories: All Tutorials

Database Developer – SQL Server/T-SQL/Database Migration

Database Developer – SQL Server/T-SQL/Database Migration

Perform actions like a Database Developer.

What you’ll learn

Database Developer – SQL Server/T-SQL/Database Migration

  • Install MS SQL Server
  • Install Oracle
  • Create database
  • Query and interact with database using T-SQL
  • Setting up a Migration Repository
  • Configuring the Third Party Database Connection
  • Capturing Source Database
  • Convert Captured Model to Oracle
  • Translate Third Party SQL Objects to Oracle
  • Generating Scripts to Create Target Database
  • Move Data from Third Party Database  to Oracle

Requirements

  • Basic understanding of Microsoft SQL Server
  • Basic understanding of Oracle database
  • Basic understanding of SQL and T-SQL

Description

One of the many roles of a database developer includes working with relational database servers, using T-SQL(Transact ) to interact with Microsoft SQL Server, and also performing database migrations from one relational database management system to another.

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 Database Developers
  • Last updated 5/2019
Content From: https://www.udemy.com/course/database-developer-sql-servert-sqldatabase-migration/
Download Now Practical Java Unit Testing with JUnit 5

Recent Posts

  • Blog

Earn Money from Areena Course

In today's digital age, opportunities for earning money have expanded significantly. One avenue that has… Read More

8 months ago
  • Blog

Best Earning Apps

Earning apps have become increasingly popular as people look for ways to make money conveniently… Read More

10 months ago
  • Blog

How to Earn Money From Markaz App

In today's fast-paced digital world, opportunities to earn money online have become increasingly popular. One… Read More

10 months ago
  • All Tutorials

Full Web Ethical Hacking Course

Full Web Ethical Hacking Course Learn all about web application penetration testing! What you'll learn… Read More

1 year ago
  • All Tutorials

Build Chatbots Using Javascript

Build Chatbots Using Javascript Build Chatbots Using Javascript From Scratch What you'll learn Build Chatbots… Read More

1 year ago
  • All Tutorials

Basic Learning about Linux Daily use commands

Basic Learning about Linux Daily use commands Basic knowledge to get you started What you'll… Read More

1 year ago