Migrating DB2 Databases to SQL Server (DB2ToSQL)

Migrating DB2 Databases to SQL Server (DB2ToSQL), available at $44.99, has an average rating of 3.36, with 21 lectures, based on 7 reviews, and has 887 subscribers.

You will learn about Create pre-migration assessment report Map DB2 Data Types to SQL Server Data Types Convert DB2 Schemas To SQL Server Schema Objects Load converted database objects into SQL Server Migrate DB2 Data into SQL Server Perform post migration data checks This course is ideal for individuals who are Beginners to data migration It is particularly useful for Beginners to data migration.

Enroll now: Migrating DB2 Databases to SQL Server (DB2ToSQL)

Summary

Title: Migrating DB2 Databases to SQL Server (DB2ToSQL)

Price: $44.99

Average Rating: 3.36

Number of Lectures: 21

Number of Published Lectures: 21

Number of Curriculum Items: 21

Number of Published Curriculum Objects: 21

Original Price: $19.99

Quality Status: approved

Status: Live

What You Will Learn

Create pre-migration assessment report
Map DB2 Data Types to SQL Server Data Types
Convert DB2 Schemas To SQL Server Schema Objects
Load converted database objects into SQL Server
Migrate DB2 Data into SQL Server
Perform post migration data checks

Who Should Attend

Beginners to data migration

Target Audiences

Beginners to data migration

IBM’s Database 2 or Db2 is a family of data management products. First released in 1983, the name Db2 was given to IBM’s Database Management System or DBMS. At that time, this database was specific to IBM’s MVS (Multiple Virtual Storage) mainframe platforms. Later, IBM extended Db2 to include other operating systems like OS/2, UNIX, MS Windows servers, Linux, and PDAs. Db2 is designed to store, analyse and retrieve data from relational databases efficiently. Beyond relational databases, Db2 also supports object-oriented features and non-relational data like XML using Db2

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.

SQL Server Migration Assistant (SSMA) for Oracle is a comprehensive environment that helps you quickly migrate Oracle databases to SQL Server, Azure SQL Database, or Azure Synapse Analytics. By using SSMA for Oracle, you can review database objects and data, assess databases for migration, migrate database objects to SQL Server, Azure SQL Database, or Azure Synapse Analytics, and then migrate data to SQL Server, Azure SQL Database, or Azure Synapse Analytics. Note that you cannot migrate SYS and SYSTEM Oracle schemas.

These days lot of customers are looking to save on their technology costs. Adopting economical technologies and software that are equally capable and powerful to fulfil requirements is one of the ways to achieve cost optimization.

Course Curriculum

Chapter 1: DB2 Setup

Lecture 1: Introduction

Lecture 2: What is DB2

Lecture 3: Installing DB2

Lecture 4: Installing IBM Data Studio

Lecture 5: Launching IBM Data Studio Client

Chapter 2: SQL Server Setup

Lecture 1: What is SQL Server

Lecture 2: SQL Server Editions

Lecture 3: Download SQL Server

Lecture 4: Install SQL Server

Lecture 5: Install SQL Server Management Studio – SSMS

Lecture 6: Connect SSMS To SQL Server

Chapter 3: Migrating DB2 Databases To SQL Server

Lecture 1: Install SQL Server Migration Assistant -SSMA

Lecture 2: Create a new SSMA Project

Lecture 3: Connect to DB2 from SSMA

Lecture 4: Connect to SQL Server from SSMA

Lecture 5: Perform a pre-migration assessment report

Lecture 6: Map DB2 Schemas to SQL Server Schemas

Lecture 7: Convert DB2 Schemas to SQL Server

Lecture 8: Load converted database Objects into SQL Server

Lecture 9: Migrate DB2 Data To SQL Server

Lecture 10: Post Migration Data Checks

Instructors

Bluelime Learning Solutions
Making Learning Simple

Rating Distribution

1 stars: 2 votes
2 stars: 0 votes
3 stars: 1 votes
4 stars: 2 votes
5 stars: 2 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu