Data migration from Oracle to SQL Azure DB

Question

Hi,

Recently we have migrated the database from Oracle to Azure SQL.

As part of performance tuning, i am planning to find the poor code, so that i can work with developers.

Is there any tool/script to find out the poor code?

Answer 1

Hi,

Is there any tool/script to find out the poor code?

Which code? the code which you used for the migration or maybe you mean poor table structure after the migration? You request is not clear. please try to clarify and elaborate

Off-topic: By the way, there is a great step by step tutorial on migrating from oracle to azure database here:

https://learn.microsoft.com/en-us/azure/azure-sql/migration-guides/database/oracle-to-sql-database-guide

Answer 2

Hi @Vijay Kumar ,

You can start from below MS document. This document show you some of the common performance scenarios encountered after migrating to SQL Server Platform and how to resolve them.

Post-migration Validation and Optimization Guide

For migrate Oracle to Azure SQL, you can start from the MS document that pituach offered or read below blog.

Steps to Migrate Oracle Database to Azure SQL Database

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 3

The obvious tool to use is Query Store.

This is the starting point in the documentation: http://learn.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store

Here is a series of articles written my my MVP colleague Enciro van der Laar: https://www.red-gate.com/simple-talk/databases/sql-server/database-administration-sql-server/the-sql-server-2016-query-store-overview-and-architecture/