This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
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