October 5, 2018 Mayank Baweja

Pricing information

25 USD

Duration

8 Hours

Audience

Application developer

SQL Developer

Database Administrator

Technologies

Azure App Services

Azure Database Migration Service (DMS)

Azure SQL Database

Azure SQL Data Warehouse

Data Migration Assistant (DMA)

SQL Server 2008 R2 and 2017

SQL Server Management Studio (SSMS)

SQL Server Migration Assistant (SSMA)

Visual Studio 2017

Data Platform Upgrade And Migration – 8 HRS Hands-on Workshop

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. In this hands-on lab, you will implement a proof of concept (POC) for conducting 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 help the customer take advantage of new SQL Server features to improve performance and resiliency, as well as conduct a migration from an old version of SQL Server to Azure SQL Database

Agenda

3 H

Deploy SQL Server instances

Install SQL Server 2017
Install SQL Server 2008 R2
Install Adventure Works sample database
Update SQL Server settings using Configuration Manager
Add inbound port rule
Copy the SqlServerDw VM IP address

3 H

Migrate SQL Server to Azure SQL Database using DMS

Register the Microsoft Data Migration resource provider
Create Azure Database Migration Service
Assess the on-premises database
Migrate the database schema
Create a migration project
Run the migration
Verify data migration

1 H

Post upgrade enhancement

Table compression
Clustered Column Store index

3 H

Setup Oracle 11g Express Edition

Install Oracle XE
Install Oracle Data Access components
Install SQL Server Migration Assistant for Oracle
Install dB Forge Fusion tool
Create the Northwind database in Oracle 11g XE
Configure the Starter Application to use Oracle

1 H

Migrate the Oracle database to SQL Server 2017

Create Northwind database
Migrate the Oracle database to SQL Server 2017 using SSMA

1 H

Migrate the Application

Create a new Entity Model against SQL Server
Modify Application Code