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
1. Procedures, Functions, Triggers, Tables, Views and other database objects from DB2 SQL to T-SQL.
2. DB2 SQL built-in and user-defined datatypes to T-SQL.
3. DB2 SQL built-in functions into corresponding T-SQL functions.
4. DB2 SQL queries into SQL Server SQL Queries.
5. Cursor Declarations, OPEN, FETCH, and CLOSE statements.
6. Result-Set Processing from DB2 SQL to T-SQL.
7. Supports SET and SELECT assignment statements.
8. DB2 SQL Conditional and Control statements.
9. DB2 SQL Label.
10. DB2 SQL GOTO statements.
11. Transaction features such as 'COMMIT', 'ROLLBACK' and 'SAVEPOINT'.
12. DB2SQL Temporary Table conversion.
13. DB2 SQL Associate Cursor statements.
14. DB2 SQL Allocate Cursor statements.
15. DB2 SQL Get Diagnostic statements.
16. DB2 SQL EXECUTE and EXECUTE IMMEDIATE statements.
17. Values Into statements.
18. DB2 SQL Exception handling statements.
19. 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.