Home
> Products > DB2 to SQL Server
Migration Tool
SwisSQL - DB2 to SQL Server Migration Tool 1.2
SwisSQL - End of Life Notice Thanks for your interest inSwisSQL
Regret to inform you that we have decided to discontinue any development and investments on this product to best align with our business goals and direction. Existing customers of SwisSQL can avail product support from us till their current support contract expires. For further queries, do email us at support@swissql.com and we'll be happy to assist you.
Migrate IBM DB2 UDB SQL to Microsoft SQL Server Transact-SQL
SwisSQL-DB2 to SQL Server Migration Tool helps you migrate
IBM DB2 SQL Procedures, Functions and Triggers to SQL Server
Transact-SQL. Microsoft SQL Server is now considered more
of an enterprise database than ever before. When enterprises
migrate from IBM DB2 UDB to SQL Server, application migration
is one of the tedious tasks and there are no good tools which
can ease the process of migrating DB2 SQL Stored Procedures
to SQL Server T-SQL Stored Procedures. Using SwisSQL-DB2 to
SQL Server Migration Tool and through SwisSQL's superior
support, enterprises can realize significant time and cost
savings during the migration and testing process.
SwisSQL Features : SwisSQL DB2 to SQL Server Migration Tool
converts
Procedures, Functions, Triggers, Tables, Views and other
database objects from DB2 SQL to T-SQL.
DB2 SQL built-in and user-defined datatypes to T-SQL.
DB2 SQL built-in functions into corresponding T-SQL functions.
DB2 SQL queries into SQL Server SQL Queries.
Cursor Declarations, OPEN, FETCH, and CLOSE statements.
Result-Set Processing from DB2 SQL to T-SQL.
Supports SET and SELECT assignment statements.
DB2 SQL Conditional and Control statements.
DB2 SQL Label.
DB2 SQL GOTO statements.
Transaction features such as 'COMMIT', 'ROLLBACK' and
'SAVEPOINT'.
DB2SQL Temporary Table conversion.
DB2 SQL Associate Cursor statements.
DB2 SQL Allocate Cursor statements.
DB2 SQL Get Diagnostic statements.
DB2 SQL EXECUTE and EXECUTE IMMEDIATE statements.
Values Into statements.
DB2 SQL Exception handling statements.
Almost all other DB2 SQL syntaxes into SQL Server Transact
SQL.
SwisSQL DB2 to SQL Server Migration Tool GUI Features:
Provides an Intuitive and Easy to use GUI for handling
the migration.
One click conversion of DB2 SQL to Transact-SQL.
Provides a tree view of loaded DB2 SQL files and converted
SQL Server Transact-SQL files.
Options to load DB2 SQL files from local directory or
import them from DB2 database for SQL Server 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 DB2 SQL file, converted
SQL Server Transact-SQL file, log report and error reports.
Provision to compile the converted SQL Server Transact
code.
