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 80% 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: - 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.