Data migration from Oracle to SQL Azure DB

Vijay Kumar 2,016 Reputation points
2022-02-03T23:55:48.063+00:00

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?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,891 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,563 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Ronen Ariely 15,096 Reputation points
    2022-02-04T00:25:17.097+00:00

    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

    0 comments No comments

  2. CathyJi-MSFT 21,096 Reputation points Microsoft Vendor
    2022-02-04T00:50:46.097+00:00

    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".


  3. Erland Sommarskog 102.3K Reputation points
    2022-02-04T22:54:18.093+00:00
    0 comments No comments