Toll Free US: +1 888 720 9500  |  Intl: +1 925 924 9500
+1 800 443 6694 (alternative number)
Store | Reseller
  • Support & Services
  • |
  • Products
  • |
  • Downloads
  • |
  • News
  • |
  • About Us
  • |
  • Contact Us
  • |
  • Feedback
All Products
OEM's Developers & Web Testing Products Enterprise Products Database Products How To Buy
Database Tools & Search
SwisSQL DBChangeManager
SwisSQL Database Migration Products
Stored Procedure Migration Tools

Home > Products > SQL Server to DB2 Migration Tool
 

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

SwisSQL SQL Server to DB2 Migration Tool
SwisSQL SQL Server to DB2 Migration Tool Supported Databases

Want to Migrate
Data too ?
SwisSQL
Data Migration
Migrate Schema and Data from
SQL Server to DB2.
More Info SwisSQL Data Migration Tool More Info
Download SwisSQL Data Migration Tool Download
  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


Source Database Target Database
MS SQL Server 2000
IBM DB2 UDB 8.x

Download SwisSQL - SQL Server to DB2 Migration Tool
 
Quick Links
  • SwisSQL Home
  • Support
  • SwisSQL Migration Solution
  • System Requirements
  • Customers
  • Customer Testimonials
  • Migration Services
  • Partners
 
 
Related products
    Data Migration
    • SwisSQL Data Migration Tool
    SQL Query Migration
    • SwisSQL Console
    • SwisSQL API (Java)
    • SwisSQL API (.NET)
    Stored Procedure Migration
    • Oracle to DB2 Migration Tool
    • SQL Server to DB2 Migration Tool
    • Sybase to DB2 Migration Tool
 
Forums
View All Forums

AdventNet Inc., the provider of enterprise IT management software announced that the latest version of ManageEngine OpManager, the number one network monitoring solution, now supports integration with the latest version of ManageEngine Firewall Analyzer, a globally recognized firewall log analysis and reporting solution. Integrating OpManager with Firewall Analyzer allows network administrators to monitor their Server's Security, Traffic, & Bandwidth utilization in depth.
PCDistrict

More »

NFMT, March 4-6, 2008, Baltimore, MA, Booth 273

HDI 2008, March 8-12, 2008, Dallas, Texas, Booth 330

Spring VON, March 17-20, 2008, San Jose, CA, Booth 542

16th Convergence India 2008, 19th-21st March 2008, Pragati Maidan, New Delhi - Booth #D19,Hall 12

More »

AdventNet, Inc. All rights reserved. Trademarks | Privacy Policy | Site Map | Contact Us | Careers | Tell Us