SwisSQL - Oracle to SQL Server Migration

Migrate Oracle PL/SQL to Microsoft SQL Server Transact-SQL

SwisSQL - Oracle to SQL Server Migration offers accurate and automated conversion of Oracle PL/SQL to SQL Server T-SQL syntaxes. The migration solution is available as a free online service and a downloadable version.

SwisSQL Oracle to SQL Server Migration solution converts

1. Procedures, Functions, Triggers, Views and Packages from PL/SQL to Transact-SQL. Supports both Named and Anonymous PL/SQL blocks
2. Variables, Cursors defined in Package Specification and Package Body
3. Procedure calls made inside another procedure
4. PL/SQL built-in and user-defined Data types To Transact SQL
5. PL/SQL built-in Functions conversion into corresponding Transact SQL Functions
6. Built-in packages like DBMS_OUTPUT & DBMS_SQL
7. Cursor Declaration, OPEN, FETCH and CLOSE Statements, Cursor Variables and Implicit Cursors
8. REF Cursor and Parameterised Cursor variables into Transact-SQL
9. %ROWCOUNT, %FOUND, %NOTFOUND and %ISOPEN for both implicit and explicit cursor attributes
10. Oracle Collection Types
11. Oracle Hierarchical queries done using START WITH and CONNECT BY constructs
12. Oracle Sequence Objects
13. Oracle Materialized Views
14. PL/SQL Label Conversions
15. Scalar and Record Anchor variables
16. Conditional and control statements
17. Pseudo column ROWNUM, LEVEL,ROWID
18. User Defined Exceptions
19. PL/SQL IN OUT mode conversion
20. Native Dynamic SQL Statements(NDS) conversion, including "EXECUTE IMMEDIATE .... INTO" statements
21. Transaction features - COMMIT, ROLLBACK and SAVEPOINT
22. Oracle SQL queries to Transact-SQL Queries including Theta joins, DECODE, '||' operator and others
23. SQLCODE and SQLERRM function

Supported Database Versions