Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

oracle statements to MSSQL statements URGENT

Status
Not open for further replies.

DvDvDvDv

Programmer
May 24, 2001
100
PT
Is anyone aware of a place I can get a software which translates oracle statements to MSSQL statements ??

If nobody knows where I can fins this software, please let me know where I can get information of how to do it.



Thanks All


Dv
 
MS SQL 7 and 2000 are ANSI92 compliant. (And depending on what version you have, Oracle may be too?)

But both products use proprietary extensions that programmers often take advantage of when coding applications. So a statement from Oracle might be directly transferable to MS-SQL, or it might not be (depending on the use of these extensions.)

Do you have an example of a statement you are trying to convert? (Or perhaps it's a whole application you are trying to migrate. If so, I'm not aware of any product that will 'translate' sql code; maybe someone else is though)
 
Hi,

I had some problems with commands like NVL, TRANSLATE or GROUPS to query serveral selects within on row

Thanks for your help

Dv
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top