|
|
SwisSQL - Oracle to SQL Server Migration Tool
-
Version
2.5
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:
- 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.
|