SwisSQL - Oracle to Sybase Migration Tool 2.7

Migrate Oracle PL/SQL to Sybase ASE Transact-SQL

SwisSQL - Oracle to Sybase Migration Tool helps you migrate Oracle PL/SQL Packages, Procedures and Functions to Sybase Transact-SQL. When enterprises migrate from Oracle to Sybase, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating Oracle Stored Procedures to Sybase Transact-SQL. Using SwisSQL - Oracle to Sybase Migration Tool and through AdventNet's superior support, enterprises can realize significant time and cost savings during the migration and testing process.

SwisSQL Features: SwisSQL Oracle to Sybase Migration Tool converts

1. Procedures, Functions, 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 into corresponding Transact SQL Procedures.
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 variables into Transact-SQL.
   
9. %ROWCOUNT, %FOUND, %NOTFOUND and %ISOPEN cursor attributes.
   
10. Sequence Objects.
11. PL/SQL Label.
    
12. Scalar and Record Anchor variables.
13. User Defined Exceptions.
14. PL/SQL IN OUT parameters.
15. Native Dynamic SQL Statements(NDS).
16. Collection type.
17. Transaction features - COMMIT, ROLLBACK and SAVEPOINT.
    
18. Conditional and control statements.
    
19. The tool provides mechanism to configure Data type mapping to be used during migration through a configuration file.

SwisSQL Oracle to Sybase Migration Tool GUI Features:

• Provides an Intuitive and Easy to use GUI for handling the migration.
• One click conversion of PL/SQLs to Sybase Transact SQL.
• Provides a tree view of loaded PL/SQL files and converted T-SQL files.
• Options to load PL/SQL files from local directory or import them from Oracle database for Sybase Transact SQL conversion.
• Project driven organization to ease maintenance.
• Generates formatted Transact SQL code with comments.
• Comprehensive migration reports with detailed information such as total number of files loaded, total number of files converted, total number of files not converted, destination directory of converted files.
  
• Provides a unified view with loaded PL/SQL file, converted T-SQL file, log report and error reports.
• Provision to compile the converted T-SQL code into the Sybase ASE database.

Supported Database Versions