This week's book giveaway is in the Cloud/Virtualization forum.
We're giving away four copies of Pipeline as Code and have Mohamed Labouardy on-line!
See this thread for details.
Win a copy of Pipeline as Code this week in the Cloud/Virtualization forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Ron McLeod
  • Paul Clapham
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Rob Spoor
  • Henry Wong
  • Liutauras Vilda
Saloon Keepers:
  • Tim Moores
  • Carey Brown
  • Stephan van Hulst
  • Tim Holloway
  • Piet Souris
Bartenders:
  • Frits Walraven
  • Himai Minh
  • Jj Roberts

pl/sql to ms sql convertion

 
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Folks,

I need to convert my scripts/procedures/functions developed on oracle to ms sql format. Is there a tool (hopefully Open Source) to do this?

Thank you.

Regards,
 
jenita brown
Ranch Hand
Posts: 51
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
no answers yet???
 
author & internet detective
Posts: 40521
825
Eclipse IDE VI Editor Java
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Just so you get a reply - I suspect such a tool doesn't exist. You could check with Microsoft if they have a recommend migration approach. Oracle wouldn't make things easy to get out of their software. And seeing how this is an Oracle forum, people are more likely to know about Oracle here than Sql Server.
 
Ranch Hand
Posts: 338
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Jenal Dhar wrote:Hi Folks,

I need to convert my scripts/procedures/functions developed on oracle to ms sql format. Is there a tool (hopefully Open Source) to do this?

Thank you.

Regards,



I don't think such a tool exists since there isn't a one-to-one conversion available for that... you are trying to move from a database designed to be scalable for an enterprise to a database that is limited even as a department level database.

Some things to keep in mind procedures are treated differently in MS Access... Output parameters cannot be used, Temporary tables are unavailable, substitution variables for local variables often do no work as expected.

I did (briefly) check to see if there is something that converts Microsoft's SQL server to Microsoft Access... I operating on the theory if there was an enterprise to department database conversion for access, it would be provided within Microsoft's product family... I didn't find anything, but I didn't look for long either.

This may be one of those cases where it will take longer looking for something to get 80% of the work done for you, than it will to just to do the conversion manually.
 
I like tacos! And this tiny ad:
SKIP - a book about connecting industrious people with elderly land owners
https://coderanch.com/t/skip-book
reply
    Bookmark Topic Watch Topic
  • New Topic