http://www.swissql.com/products/sqlserver-to-oracle/sql-server-to-oracle.html SwisSQL Features: SwisSQL SQL Server to Oracle Migration Tool converts 1. Full-fledged support for conversion of Inline and Multi-Statement Table valued user-defined functions in SQL Server. 2. Option to generate Index Organized Tables in Oracle. 3. Configurability to separate the Constraint definitions from the Table definition so that the Oracle database can be built with ease (in that order) 4. Option to specify the TABLESPACE to be used for Tables and Indexes in Oracle while creating them. 5. Procedures, Functions, Triggers, Tables, Views and other database objects to Oracle PL/SQL. 6. Transact-SQL built-in and user-defined Datatypes To Oracle PL/SQL. 7. Transact-SQL Built-in Functions conversion into corresponding Oracle PL/SQL Functions. 8. SQL-Server SQL queries conversion into Oracle SQL Queries. 9. Cursor Declaration, OPEN, FETCH, CLOSE and DEALLOCATE Statement Conversion. 10. Single Result-Set Processing conversion from T-SQL to PL/SQL. 11. SET and SELECT assignment statements and T-SQL Labels. 12. Transact SQL Conditional and Control Statements. 13. Support for EXECUTE / EXEC Statements conversion. 14. @@FETCH_STATUS, @@ROWCOUNT, @@ERROR, @@LANGUAGE, @@MAX_CONNECTIONS and @@VERSION Global Variables. 15. Transact SQL Temporary table. 16. Transaction features COMMIT, ROLLBACK and SAVEPOINT. 17. Bitwise operators. 18. Database definitions (CREATE DATABASE.. construct). 19. User accounts (Logins) present in SQL Server database into equivalent scripts in Oracle. 20. SCOPE_IDENTITY() function. 21. Almost all other SQL Server Transact SQL syntaxes into Oracle PL/SQL. 22. Option to customize the database object names while migrating the SQL Server Transact-SQL scripts to Oracle PL/SQL. 23. Support for runtime customization of data types (mapping data types in SQL Server to any preferred data type in Oracle) before conversion. 24. Support for handling the conversion of variable names with length greater than 30 characters. 25. Migration Assessment Tool : This new tool can be used to assess the complexity and percentage of automated conversion of the source SQL Server database objects that needs to be migrated to Oracle. The detailed assessment reports generated by the tool will be helpful in arriving at an estimation for the migration project to be undertaken.
SwisSQL Features: SwisSQL SQL Server to Oracle Migration Tool converts 1. Full-fledged support for conversion of Inline and Multi-Statement Table valued user-defined functions in SQL Server.
2. Option to generate Index Organized Tables in Oracle.
3. Configurability to separate the Constraint definitions from the Table definition so that the Oracle database can be built with ease (in that order)
4. Option to specify the TABLESPACE to be used for Tables and Indexes in Oracle while creating them.
5. Procedures, Functions, Triggers, Tables, Views and other database objects to Oracle PL/SQL.
6. Transact-SQL built-in and user-defined Datatypes To Oracle PL/SQL.
7. Transact-SQL Built-in Functions conversion into corresponding Oracle PL/SQL Functions.
8. SQL-Server SQL queries conversion into Oracle SQL Queries.
9. Cursor Declaration, OPEN, FETCH, CLOSE and DEALLOCATE Statement Conversion.
10. Single Result-Set Processing conversion from T-SQL to PL/SQL.
11. SET and SELECT assignment statements and T-SQL Labels.
12. Transact SQL Conditional and Control Statements.
13. Support for EXECUTE / EXEC Statements conversion.
14. @@FETCH_STATUS, @@ROWCOUNT, @@ERROR, @@LANGUAGE, @@MAX_CONNECTIONS and @@VERSION Global Variables.
15. Transact SQL Temporary table.
16. Transaction features COMMIT, ROLLBACK and SAVEPOINT.
17. Bitwise operators.
18. Database definitions (CREATE DATABASE.. construct).
19. User accounts (Logins) present in SQL Server database into equivalent scripts in Oracle.
20. SCOPE_IDENTITY() function.
21. Almost all other SQL Server Transact SQL syntaxes into Oracle PL/SQL.
22. Option to customize the database object names while migrating the SQL Server Transact-SQL scripts to Oracle PL/SQL.
23. Support for runtime customization of data types (mapping data types in SQL Server to any preferred data type in Oracle) before conversion.
24. Support for handling the conversion of variable names with length greater than 30 characters.
25. Migration Assessment Tool : This new tool can be used to assess the complexity and percentage of automated conversion of the source SQL Server database objects that needs to be migrated to Oracle. The detailed assessment reports generated by the tool will be helpful in arriving at an estimation for the migration project to be undertaken.