none
oracle to Azure sql Dwh code conversion tool? RRS feed

  • Question

  • We are planning to move from oracle to Azure SQL DWH. is there any tool available to convert the pl/sql code,mviews & views into SQL dwh compatablity?
    Friday, November 8, 2019 8:37 AM

All replies

  • Azure SQL DW language doesn't have anything different than general SQL language. It might have a few limitations though.

    You can search for oracle to sql conversion online and use any of it.

    e.g.

    http://www.sqlines.com/online 


    Regards,
    Vaibhav

    Friday, November 8, 2019 10:37 AM
  • We are planning to move from oracle to Azure SQL DWH. is there any tool available to convert the pl/sql code,mviews & views into SQL dwh compatablity?

    Please see the following planning guide to get started: Migrate Oracle to SQL Data Warehouse by selecting your source and target. What you will see are a list of resources available to help with a successful migration.

    Please let me know if you have additional questions.

    Regards,

    Mike

    Friday, November 8, 2019 11:42 PM
    Moderator
  • Just checking in to see if the above answer(s) helped.

     

    If this answers your query, do click “Mark as Answer” and Up-Vote for the same which might be beneficial to other community members reading this thread .

    And, if you have any further query do let us know. 

    Monday, November 11, 2019 3:37 AM
    Moderator