http://www.perlmonks.org?node_id=580734


in reply to Oracle to MSSQL translation

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.

Replies are listed 'Best First'.
Re^2: Oracle to MSSQL translation (!data def)
by tye (Sage) on Oct 26, 2006 at 13:32 UTC

    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