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

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.