SwisSQL - SQL Server to DB2 Migration Tool 1.4

Migrate Microsoft SQL server Transact SQL to IBM DB2 UDB SQL

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 AdventNet's 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

1. Transact-SQL procedures, functions, triggers, and other database componets to DB2 SQL.
2. Transact-SQL built-in and user-defined datatypes to DB2 SQL.
3. Transact-SQL Built-in functions to corresponding DB2 functions.
4. SQL-Server SQL queries to DB2 SQL queries.
5. Transact-SQL Cursor Declaration, OPEN, FETCH and CLOSE statements.
6. Single Result-Set Processing from Transact-SQL to DB2 SQL.
7. Transaction features such as COMMIT and ROLLBACK.
8. Transact-SQL SET and SELECT assignment statements.
9. Transact-SQL Conditional and Control Statements.
10. All Transact-SQL statements to DB2 SQL.
11. Transact SQL @@FETCH_STATUS, @@ROWCOUNT and @@ERROR global variables.
12. Transact SQL temporary tables.
13. Transact SQL label.
14. Transact-SQL scalar functions to DB2 scalar functions.
15. Transact-SQL inline table-valued functions to DB2 table functions.
16. Support for conversion of Cursor declared Transact-SQL Scalar functions into DB2 procedures.
17. Multiple Result-Set Processing.
18. Support for configuring the data type mapping that needs to be used while converting SQL Server
    data types into equivalent DB2 data types.
19. Support for Transact-SQL INSTEAD OF Triggers into DB2 SQL.
20. Almost all other SQL Server Transact SQL syntaxes into DB2 SQL.

SwisSQL SQL Server to DB2 Migration Tool GUI Features:

• Provides an Intuitive and Easy to use GUI for handling the migration.
• One click conversion of 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 SQL Server 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