Database Migration Solutions for IBM DB2 UDB
|
Enterprises migrate their mission-critical applications
and data from other databases to IBM DB2 UDB to take
advantage of its flexible and cost-effective database
platform with business intelligence tools. AdventNet
SwisSQL's complete range of database migration tools
for IBM DB2 UDB helps customers to migrate their business
environment to IBM DB2 UDB without tedious manual migration
effort.
|
 |
|
SwisSQL assists customers in migrating their business
environment to IBM DB2 UDB and instantly leverage benefits
through:
-
Stored Procedure Migration Tools that completely
automate stored procedure migration from Oracle
PL/SQL, SQL Server Transact-SQL, and Sybase Transact-SQL
to IBM DB2 SQL.
-
SQL Migration Tool completely migrates SQL statements
from Oracle, MS SQL Server, and Sybase ASE, MySQL,
Informix or PostgreSQL to IBM DB2 UDB SQL statements
-
Data Migration Tool completely migrates schema
and data from wide range of databases to IBM DB2
UDB.
Customers can use SwisSQL Migration Tools on database
migration projects of any size and automate migration
up to 90% with 80% savings in time and cost . All SwisSQL
products are available on a free 30-day evaluation.
|
| Migrate
Oracle PL/SQL Stored Procedures to IBM DB2 SQL |
 |
|
Complete migration of your business logic based on
Oracle PL/SQL stored procedures to IBM DB2 SQL. SwisSQL-
Oracle to DB2 Migration Tool can assist you to migrate
Oracle PL/SQL Procedures, Functions, Triggers, and other
MS SQL Server specific objects to IBM DB2 SQL.
|
| Migrate
MS SQL Server Transact-SQL Stored Procedures to IBM DB2
SQL |
 |
|
Complete migration of your business logic based on
MS SQL Server Transact-SQL stored procedures to IBM
DB2 SQL. SwisSQL- SQL Server to DB2 Migration Tool can
assist you to migrate MS SQL Server Transact-SQL Procedures,
Functions, Triggers, and other SQL Server specific objects
to IBM DB2 SQL.
|
| Migrate
Sybase Transact-SQL Stored Procedures to IBM DB2 SQL |
 |
|
Complete migration of your business logic based on
Sybase Transact-SQL procedures to IBM DB2 SQL. SwisSQL-
Sybase to DB2 Migration Tool can assist you to migrate
Sybase T-SQL Procedures, Functions, Triggers, and other
Sybase ASE specific objects to IBM DB2 SQL.
|
| Migrate embedded SQL
queries in your application to IBM DB2 UDB |
 |
|
|
SQL statement embedded in your application can be seamlessly
migrated to Oracle by using SwisSQL API. SwisSQL API assists in converting SQL statements from any database
dialect to IBM DB2 UDB in real-time. It enables applications
to work with multiple databases without requiring to
port SQL statements across a wide range of database
such as IBM DB2 UDB, Oracle, MS SQL Server, Sybase ASE,
MySQL, Informix, and PostgreSQL. Applications can embed
SwisSQL API into their application or can transparently
use SwisSQL API ODBC/JDBC wrapper. SwisSQL API is available in
both .NET and Java editions.
|
| SQL Query conversion
tool for DBAs and Developers |
 |
|
SwisSQL Console is a user-friendly GUI tool
that converts SQL queries from any database dialect
to IBM DB2 UDB. Developers and DBAs can type SQL queries
in any SQL dialect and instantaneously view equivalent
queries in IBM DB2 UDB. SwisSQL Console supports
SQL query conversion across IBM DB2 UDB, Oracle, MS
SQL Server, Sybase ASE, MySQL, Informix, and PostgreSQL.
It is a highly productive and useful tool for DBAs and
Developers working on migration projects or multiple
databases.
|
| Migrate your data from
any database to Oracle |
 |
|
SwisSQL Data Migration Edition migrates schema and
data from any database to Oracle. Data Migration Tool
assists in the migration of database schema, views,
indexes and data from wide range of databases such as
Oracle, MS SQL Server, IBM DB2 UDB,Sybase ASE, MySQL
MaxDB (SAP DB), and MySQL to IBM DB2 UDB.
|
|
Supported Database
Versions
|
| Stored Procedure
Migration |
| Source
Database |
Target
Database |
- Oracle 8.1.6, 8.1.7, 9i, and 10g
- MS SQL Server 2000
- Sybase ASE 12.x
|
- IBM DB2 UDB for Linux, Unix, and Windows 8.x
- IBM DB2 UDB for Linux, Unix, and Windows 8.x
- IBM DB2 UDB for Linux, Unix, and Windows 8.x
|
| SQL Query Migration |
| SQL Migration
is supported across the following databases |
- Oracle 8.1.7, 9i, and 10g
- MS SQL Server 2000
- IBM DB2 UDB for Linux, Unix, and Windows 8.x
- Informix 4.x
- Sybase ASE 12.x
- MySQL 4.X
- PostgreSQL 7.x and
- ANSI-SQL - SQL 92 and SQL 99
|
| Data Migration |
| Source Database |
Target Database |
- Oracle 8i,9i, and 10g
- IBM DB2 UDB for Linux, Unix, and Windows 8.x
- MS SQL Server 2000
- Sybase ASE 12.x, 11
- MySQL 4.0.x and 3.23.x
- MySQL MaxDB (SAP DB) 7.5.00
|
- Oracle 9i, and 10g
- IBM DB2 UDB for Linux, Unix, and Windows 8.x
- MS SQL Server 2000
- Sybase ASE 12.x and 11
- MySQL 4.0.x, 3.23.x, and 5.0 Beta
|
|
|
. |
Data
Migration
SQL Query Migration
Stored Procedure Migration
|