Beefy Boxes and Bandwidth Generously Provided by pair Networks
laziness, impatience, and hubris

Oracle to MSSQL translation

by Tabari (Monk)
on Oct 26, 2006 at 10:42 UTC ( #580729=perlquestion: print w/replies, xml ) Need Help??
Tabari has asked for the wisdom of the Perl Monks concerning the following question:

I have a series of Oracle PL/SQL code creating procedures and functions which I need to migrate to MSSQL. Apart from that , some DDL statements such as table/column/index creation need to be translated too. Is there some CPAN module or some other starting point for this exercise? The translation need not necessarily be complete in all details, I'd be very glad if the tedious task of doing it all is a bit alleviated

Replies are listed 'Best First'.
Re: Oracle to MSSQL translation
by Hofmator (Curate) on Oct 26, 2006 at 11:14 UTC
    Well, not directly perl related question, but there seems to be a perl solution to at least part of your problem: SQL::Translator. Btw, this was suggested yesterday in the chatterbox after your question there ...

    -- Hofmator

    Code written by Hofmator and posted on PerlMonks is public domain. It is provided as is with no warranties, express or implied, of any kind. Posted code may not have been tested. Use of posted code is at your own risk.

      And after it was mentioned, I mentioned in the CB that SQL::Translator only translates data definitions ("create table") and that I guessed that such is the less likely option if someone is asking to "translate SQL". Indeed, the node says that their SQL is for creating functions and procedures, so I don't think SQL::Translator will be much help.

      Update: Ah, I see that some data def translation is also mentioned and this is probably what you meant by "part of your problem", but I'm glad to have stated explicitly what part.

      - tye        

Re: Oracle to MSSQL translation
by bart (Canon) on Oct 26, 2006 at 11:11 UTC

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://580729]
Approved by Corion
and all is quiet...

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (3)
As of 2018-02-24 04:35 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (310 votes). Check out past polls.