| 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
