Sql – How to Convert SQL server to Oracle


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

Best Solution

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.