• Post category:StudyBullet-4
  • Reading time:9 mins read




Migrate MySQL to SQL Server and SQL Server to Oracle

What you will learn

 

Migrating MySQL Database to Microsoft SQL Server Database

 

Migrating Microsoft SQL Server Database to Oracle

 

Installing SQL Server Migration Assistant for MySQL -SSMA

 

Perform pre-migration steps

 

Setup connections to source and target database servers

 

Validate Type mappings

 

Convert Schema

 

Migrate Schema and Data

 

Connect to third party database

 

Capture third party source data

 

Generate migration scripts

Description

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation.

The SQL part of “MySQL” stands for “Structured Query Language”. SQL is the most common standardized language used to access databases. Depending on your programming environment, you might enter SQL directly (for example, to generate reports), embed SQL statements into code written in another language, or use a language-specific API that hides the SQL syntax.

A database is a structured collection of data. It may be anything from a simple shopping list to a picture gallery or the vast amounts of information in a corporate network. To add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Since computers are very good at handling large amounts of data, database management systems play a central role in computing, as standalone utilities, or as parts of other applications.

MySQL is Open source which means that it is possible for anyone to use and modify the software. Anybody can download the MySQL software from the Internet and use it without paying anything. If you wish, you may study the source code and change it to suit your needs.

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 (including the Internet). Microsoft markets at least a dozen different editions of Microsoft SQL Server, aimed at different audiences and for workloads ranging from small single-machine applications to large Internet-facing applications with many concurrent users.

Database migration is the process of migrating data from one or more source databases to one or more target databases by using a database migration service. When a migration is finished, the datasets in the source databases resides fully, though possibly restructured, in the target databases.


Get Instant Notification of New Courses on our Telegram channel.


In this course you will learn how to migrate a database from MySQL into Microsoft SQL Server using SQL Server Migration Assistant for MySQL (SSMA). The migration will involve schema and data migration.

 

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.

 

English
language

Content

Introduction

Course Introduction
What is MySQL
What is Oracle
What is Microsoft SQL Server
Database Concepts
Database Schema

Oracle Database Setup

Installation Requirements
Install Oracle Database Server
SQLplus
Unlock sample schema for Oracle
Install Oracle Developer
Connect to Oracle Database

Microsoft SQL Server Setup

Minimum Installation Requirements for SQL Server
SQL Server Editions
Download Microsoft SQL Server
Install Microsoft SQL Server
Install SQL Server Management Studio
Connect to SQL Server with SSMS
Install Sample Database

Database Migration: SQL Server To Oracle

Creating a database user
Creating a repository
Configuring third party database connection – Part 1
Configuring third party database connection – Part 2
Capturing data source
Converting captured model to Oracle
Translating third party T-SQL objects to Oracle
Generating scripts to create target database
Moving data from SQL Server into Oracle

MySQL Database Server Setup

MySQL Download Link
Install MySQL on Windows
Install MySQL on Macs
MySQL Workbench
Install MySQL Workbench on Macs
MySQL Data Types

Database Migration: MySQL To SQL Server

Installing SSMA
Prerequistes
SQL Server Agent
Pre-migration assessment
Validating type mappings
Converting the schema
Performing the migration
Post migration data validation