SwisSQL - Oracle to Sybase Edition is an automated migration tool to convert stored procedures implemented in Oracle PL/ SQL into equivalent Sybase Adaptive Server Transact SQL code.

It automates more than 80% of the PL/ SQL code conversion into TransactSQL 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.

Here are some key features of "SwisSQL Oracle to Sybase Migration Tool":

· Migration of Oracle PL/ SQL procedures, functions, triggers, cursors, tables and views into TransactSQL
· Support for conversion of PL/ SQL In-Built Functions, Datatypes, and SQL Queries
· Support for conversion of all Transaction features.
· Support for conversion of PL/ SQL cursor variables, attributes & implicit cursors into Transact SQL.
· Support for conversion of PL/ SQL labels, conditional, control and record statements.
· Support for conversion of Sub Procedures and Sub Functions defined in declaration section of PL/SQL Block.
· Generation of formatted, readable TransactSQL code with good comments.
· Support for Native Dynamic SQL Statements(NDS) conversion.
· A user friendly Graphical user interface with support for:
o One click conversion of PL/ SQL into Sybase TransactSQL.
o Fetching PL/ SQL model from database directly and converting. Also supports conversion of source files from local directory.
o Project driven organization of converted code to ease maintenance.



Requirements: 128 MB RAM,PIII 800 MHz,50 MB hard disk space

Limitations:

· The tool can be used to convert up to 1000 lines of Oracle PL/SQL stored procedures to Sybase T-SQL stored procedures.
· The tool will expire after a period of 30 days from the date of first startup of the product.
· Bulk migration of files will be disabled in the Evaluation version. Migrations can be done only one file at a time. Bulk Migration feature would be available in the Registered Version of the product.