| Database migration from Sql Server to Oracle(urgent) [message #92477] |
Thu, 05 August 2004 22:54  |
Vijay
Messages: 116
Registered: September 1999
|
Senior Member |
|
|
Hi all,
We, have developed our application in J2EE.
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. And what are the precautions we have to take before migrating. Because, in our application we have wriiten thousends of queries, Stored Procedures, Triggers etc., based on Sql server only. But, we know that those queries, Stored Procedures, Triggers etc.won't run in Oracle. Example, 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, which will take care all these conversions.
Any Help is Greatly appreciated..
Regards
Vijay
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
