• 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 Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • paul wheaton
  • Ron McLeod
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
Bartenders:

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: 42173
937
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.
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic