Oracle to MSSQL translation

[Tabari]

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

[Hofmator]

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 ...

[tye]

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.

[bart]

I would think that's a job for the SQL Fairy, aka the module SQL::Translator.