Convertion from Sql server 2005 to Oracle 9i

Question

Hi,

I have devloped website using ASP and Sql Server 2005. I have not used any Stored Procedure and Views [All the queries are passed from the asp page]. Now i need to convert the database from SQL Server 2005 to Oracle 9i.

Will it takes huge changes in my code? Is there any tool to convert Sql Server 2005 query to Oracle query?

Answer 1

This seems kind of hard to answer. You could have Sql server specific queries, or standardized queries. It will take some tweaking, but it shouldn't be too bad if your app is well designed.

Answer 2

I don't think we can answer that without knowing how your application is designed. Did you build your data access tier or did you use an ORM? Any user defined types? Etc.

Here's an article I found on how to migrate a SQL 2005 database to Oracle 11g. This may help by pointing you in the right direction.

http://st-curriculum.oracle.com/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

EDIT: Here's a link to a useful page that compares SQL Server and Oracle (along with a few other vendors') sql syntax. This should be useful in helping you determine how much work will be required converting your app from using SQL Server to Oracle.