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
Transact SQL Procedures, Triggers, Views, Indexes and
other database objects to DB2 SQL.
Transact-SQL built-in and user-defined datatypes to DB2
SQL.
Transact-SQL built-in functions conversion into corresponding
DB2 functions.
Sybase SQL queries conversion into DB2 SQL queries.
Transact-SQL Cursor declaration, OPEN, FETCH and CLOSE
statements.
Single Result-Set processing conversion from Transact-SQL
to DB2 SQL.
Transact-SQL SELECT assignment statements.
Transact-SQL conditional and control statements.
Transact-SQL EXECUTE/EXEC statements.
Transact-SQL @@SQLSTATUS, @@ROWCOUNT, @@ERROR and @@TRANCOUNT
global variables.
Transact-SQL Label conversions.
Transaction features COMMIT and ROLLBACK.
Transact-SQL temporary tables.
Multiple Result-Set Processing.
Support for configuring the data type mapping that needs
to be used while converting Sybase data
types into equivalent DB2 data types.
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.
