This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Migrating Oracle to SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Migrating Oracle to SQL Server" Watch "Migrating Oracle to SQL Server" New topic
Author

Migrating Oracle to SQL Server

Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
Hi,
What are the necessary steps has to be taken to migrate and how it affects the SQL queries used in Oracle as there are specific functions in their own DB.
Is there any resource to verify queries to work on both the servers.
Thanks,
Anil


SCJP 1.5, SCEA, ICED (287,484,486)
Jamie Robertson
Ranch Hand

Joined: Jul 09, 2001
Posts: 1879

Most functions in oracle are specific to oracle and will have to be changed to the SQLServer equivalent(ie to_char(date,'format'), to_date('string','format'), trunc(), mod(), round()...etc.). If your programs stuck just to standard SQL then there should not be many glitches. You might have to change escape characters and maybe wildcard search characters.
I'm sure there is more, but I don't work with JDBC and SQL server to know enough.
One more thought is to make sure that the new driver for MS SQLServer has the same capabilities as the Oracle drivers.
Jamie
Anil Vupputuri
Ranch Hand

Joined: Oct 31, 2000
Posts: 527
I found one useful link,
www.geocities.com/Hollywood/Makeup/2321/sqlorcle.html
regd. everything bw both the DB's
HTH..
Anil
[This message has been edited by Anil Vupputuri (edited August 14, 2001).]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Migrating Oracle to SQL Server
 
Similar Threads
JSP with Oracle / SQL
Is it hard to use SQL Server with Java?
wether JDBC supports UNION Queries
Java and Sybase
how to find out 3rd max salary from an emp table?