SwisSQL - SQL Server to DB2 Migration Tool helps you migrate Microsoft SQL Server Transact-SQL Procedures, Functions and Triggers to IBM DB2 Stored Procedure language. When enterprises migrate from Microsoft SQL Server to DB2, application migration is one of the tedious tasks and there are no good tools which can ease the process of migrating MS SQL Server Stored Procedures to IBM DB2 Procedures. Using SwisSQL - SQL Server to DB2 Migration Tool and through AdventNets superior support, enterprises can realize significant time and cost savings during the migration and testing process.
SwisSQL Features: SwisSQL SQL Server to DB2 Migration Tool converts
Transact-SQL procedures, functions, triggers, and other database componets to DB2 SQL.
Transact-SQL built-in and user-defined datatypes to DB2 SQL.
Transact-SQL Built-in functions to corresponding DB2 functions.
SQL-Server SQL queries to DB2 SQL queries.
Transact-SQL Cursor Declaration, OPEN, FETCH and CLOSE statements.
Single Result-Set Processing from Transact-SQL to DB2 SQL.
Transaction features such as COMMIT and ROLLBACK.
Transact-SQL SET and SELECT assignment statements.
Transact-SQL Conditional and Control Statements.
All Transact-SQL statements to DB2 SQL.
Transact SQL @@FETCH_STATUS, @@ROWCOUNT and @@ERROR global variables.
Transact SQL temporary tables.
Transact SQL label.
Transact-SQL scalar functions to DB2 scalar functions.
Transact-SQL inline table-valued functions to DB2 table functions.
Support for conversion of Cursor declared Transact-SQL Scalar functions into DB2 procedures.
Multiple Result-Set Processing.
Support for configuring the data type mapping that needs to be used while converting SQL Server
data types into equivalent DB2 data types.
Support for Transact-SQL INSTEAD OF Triggers into DB2 SQL.