Home » Other » General » SQL Server T0 Oracle 10g migration Tools(urgent)
SQL Server T0 Oracle 10g migration Tools(urgent) [message #104151] Thu, 05 August 2004 22:48
Vijay
Messages: 116
Registered: September 1999
Senior Member
Hi all,

We are migrating our application from Sql Server database to Oracle. 

So, please anybody can suggest me regarding the best Tool, which will take care all the migration part. Because, in our application we have wriiten thousends of queries, Stored Procedures, Triggers etc., based on Sql server. But, we know that those queries, Stored Procedures, Triggers etc.won't run in Oracle. Because, in Sql server for getting the current date we have to use GetDate(), in Oracle SysDate..likewise so many diffrences are there in sql queries between Sql Server to Oracle.

So, we need one interpreter tool to take care all these conversions. We, have developed our application in J2EE.

Any Help is Greatly appreciated..
 
Regards
Vijay

 

 

 

 
Previous Topic: oracle client
Next Topic: RG8000
Goto Forum:
  


Current Time: Tue Nov 26 21:51:41 CST 2024