Tech Off Post

Single Post Permalink

View Thread: Dynamic MSSQL to Oracle query conversion
  • User profile image
    SlackmasterK

    I have a suite of applications that was designed against MSSQL. We have a new vendor which will involve installing our applications there, but we absolutely must use Oracle in that installation. Other customers being unaffected, we want to keep MSSQL everywhere else.

    Question 1: What are the best practices relevant to this situation?

    Question 2: Is there a way (SDK, etc) to convert TSQL queries to PSQL dynamically (without manually entering them into a UI, etc)?