Live Chat Support

Microsoft Cloud Workshop: Data Platform Upgrade and Migration (40514G)

Microsoft Cloud Workshop: Data Platform Upgrade and Migration (40514G)

Overview

Duration : 1 Day

In this workshop, you will gain a better understanding of how to conduct a site analysis for a customer to compare cost, performance, and level of effort required to migrate from Oracle to SQL Server. You will evaluate the dependent applications and reports that will need to be updated and come up with a migration plan. In addition, you will design and build a proof of concept (POC) and help the customer take advantage of new SQL Server features to improve performance and resiliency, as well as explore ways to migrate from an old version of SQL Server, to the latest version and consider the impact of migrating from on-premises to the cloud.

Objectives

At the end of this workshop, you will be better able to conduct a site analysis for compare cost, performance, and level of effort required to migrate from Oracle to SQL Server.

Course Outline

Module 1: Whiteboard Design Session - Data platform upgrade and migration

Lessons

  • Review the customer case study
  • Design a proof of concept solution
  • Present the solution

 

Module 2: Hands-on Lab - Data platform upgrade and migration

Lessons

  • Deploy SQL Server instances
  • Migrate SQL Server to Azure SQL Database using DMS
  • Post upgrade enhancement
  • Setup Oracle 11g Express Edition
  • Migrate the Oracle database to SQL Server 2017
  • Migrate the Application
None
Course ID:
40514G


Show Schedule for:

Please provide as much information as possible for us to help you with your enquiry.