SwisSQL - Sybase to DB2 Migration Tool 1.4

Migrate Sybase ASE Transact SQL to IBM DB2 UDB SQL

SwisSQL - Sybase to DB2 Migration Tool helps you migrate Sybase Transact-SQL Procedures, Views, and Triggers to IBM DB2 Stored Procedure language. When enterprises migrate from Sybase to DB2, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating Sybase Stored Procedures to IBM DB2 Procedures. Using SwisSQL - Sybase to DB2 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 Sybase to DB2 Migration Tool converts

1. Transact SQL Procedures, Triggers, Views, Indexes and other database objects to DB2 SQL.
2. Transact-SQL built-in and user-defined datatypes to DB2 SQL.
3. Transact-SQL built-in functions conversion into corresponding DB2 functions.
4. Sybase SQL queries conversion into DB2 SQL queries.
5. Transact-SQL Cursor declaration, OPEN, FETCH and CLOSE statements.
6. Single Result-Set processing conversion from Transact-SQL to DB2 SQL.
7. Transact-SQL SELECT assignment statements.
8. Transact-SQL conditional and control statements.
9. Transact-SQL EXECUTE/EXEC statements.
10. Transact-SQL @@SQLSTATUS, @@ROWCOUNT, @@ERROR and @@TRANCOUNT global variables.
11. Transact-SQL Label conversions.
12. Transaction features COMMIT and ROLLBACK.
    
13. Transact-SQL temporary tables.
14. Multiple Result-Set Processing.
    
15. Support for configuring the data type mapping that needs to be used while converting Sybase data
    types into equivalent DB2 data types.
16. Almost all other Sybase Transact SQL syntaxes into DB2 SQL.

SwisSQL Sybase to DB2  Migration Tool GUI Features:

• Provides an Intuitive and Easy to use GUI for handling the migration.
• One click conversion of Sybase Transact SQL to DB2 SQL.
• Provides a tree view of loaded Transact SQL files and converted DB2 SQL files.
• Options to load Transact SQL files from local directory or import them from Sybase database for DB2 SQL conversion.
• Project driven organization to ease maintenance.
• Generates formatted DB2 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 Transact SQL file, converted DB2 SQL file, log report and error reports.
• Provision to compile the converted DB2 SQL code.

Supported Database Versions