locked
Oracle to SQL server Migration Assessment through SSMA RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    i am planning to migrate Oracle 11g to MS SQL Server 2016,

    hence i performed Pre-Migration  assessment through SSMA.

    I received final conversion report on SSMA, But with Numerous Number of Errors.the report states that it will require 1263.6hours for manual conversion from Oracle to SQL

    Please help me, how shall i resolve these errors with minimum  manual conversion time.

    Attached are the screenshot for the same.

    Appreciate your Help 

    Thanks,

    Amit




    • Edited by Sads_02 Monday, June 29, 2020 5:50 AM
    Monday, June 29, 2020 2:26 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Amit,

    According to the screenshot, there are many problems in PL/SQL objects and user defined types.

    Please try to read this article Converting Oracle Schemas (OracleToSQL) for more details about which Oracle objects are converted and the resulting SQL Server objects.

    Actually you are suggested to have a lot of manual work to do firstly before conversion. For example, you need to rewrite most of the code and fix the PL/SQL objects problems so that they could be converted to Transaction SQL.

    After all, you need to evaluate all negative impacts even if you will still use SSMA for automatic conversions.

    Please find below link which may be helpful:

    How SSMA Estimates Manual Conversion Time

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Tuesday, June 30, 2020 6:26 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Amit,

    According to the screenshot, there are many problems in PL/SQL objects and user defined types.

    Please try to read this article Converting Oracle Schemas (OracleToSQL) for more details about which Oracle objects are converted and the resulting SQL Server objects.

    Actually you are suggested to have a lot of manual work to do firstly before conversion. For example, you need to rewrite most of the code and fix the PL/SQL objects problems so that they could be converted to Transaction SQL.

    After all, you need to evaluate all negative impacts even if you will still use SSMA for automatic conversions.

    Please find below link which may be helpful:

    How SSMA Estimates Manual Conversion Time

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com


    Tuesday, June 30, 2020 6:26 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sads_02,

    Could you please provide any update about this issue? Thanks.

     

     

    Best regards,

    Melissa

    -------------------------------------------

    MSDN Community Support

    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Monday, July 6, 2020 1:39 AM