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)?