AdventNet SwisSQL Oracle to SQL Server description
Automated migration tool to convert Oracle PL/SQL to SQL Server Transact SQL

SwisSQL - Oracle to SQL Server Edition is an Automated Migration tool to convert Oracle PL/SQL stored procedures into equivalent Microsoft SQL Server Transact SQL code.

It automates more than 90% of the Oracle PL/SQL code conversion into Transact SQL with very minimal manual intervention. SwisSQL migration tool removes the time consuming, tedious and error prone manual effort involved in typical migration projects and provides great productivity benefit with high quality output and short turnaround time.

Significant Features of AdventNet

SwisSQL - Oracle to SQL Server:

- Migration of Oracle PL/SQL packages, procedures, functions, triggers, cursors, tables and views into Transact SQL.
- Supports conversion of PL/SQL In-Built Functions, SQL Queries & all In-Built data types (including user-defined types).
- Supports conversion of most of the Oracle built-in packages including DBMS_OUTPUT, DBMS_SQL etc.,
- Supports conversion of complex query constructs like 'START WITH and CONNECT BY'.
- Supports conversion of PL/SQL cursor variables, attributes & implicit cursors into Transact SQL.
- Supports conversion of Oracle SQL queries into equivalent Transact SQL Queries including Theta joins, DECODE, '||‘ operator and others
- Generates formatted, readable Transact SQL code with very good comments
- Provides an ease to use Graphical user interface with support for single click driven migration.
- The tool supports two modes of conversion: (i). It could fetch PL/SQL model directly from database and convert them (ii) Supports conversion of PL/SQL source files loaded from local directory.