Home
> Products > SQL Server to
DB2 Migration Tool
SwisSQL - SQL Server to DB2 Migration Tool 1.5
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 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 SwisSQL'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
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.
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.
