How to Convert SQL server to Oracle ?

Question

I have a SQL server database (Tables, Views, SP...). I need to convert this database to Oracle 10g. How can I do it?

Answer 1

You basicaly setup an Oracle Server, once its ready you migrate your tables using a software made for that. I guess this script can do the job: m2o

Answer 2

sql developer can help. You can download it here , it is free. http://www.oracle.com/technology/software/products/sql/index.html

Answer 3

Transferring the data will be easy; SQL Server integration services can do that, or Oracle's SQL Developer.

However, views and stored procedures are different between Oracle and SQL Server. SQL Server uses T-SQL, Oracle uses PL/SQL. These are not very compatible and I don't know a tool can automatically convert between the two. If your database relies on specific T-SQL features, you will need a developer to do the conversion.