This week's giveaway is in the Programmer Certification (OCPJP) forum.
We're giving away four copies of Java Mock Exams (software) and have David Mayer on-line!
See this thread for details.
Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Migrating Oracle to SQL Server

 
Anil Vupputuri
Ranch Hand
Posts: 527
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
Jamie Robertson
Ranch Hand
Posts: 1879
MySQL Database Suse
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 527
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).]
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!