## SQLWays Overview

SQLWays is a database migration tool. It transfers database structures and data between IBM DB2, Oracle, Microsoft SQL Server, Sybase, MySQL and Pervasive.SQL databases.

- Supported Databases
- SQLWays Standard, SQLWays Pro and SQLWays Enterprise Editions

### Key Benefits

- Flexible, Open and Extensible Migration Process

  - Uses export/import migration architecture that provides users with the most flexible capabilities for managing the migration process.
  - Allows you to perform export on one system and then execute import on another system and platform (Windows or Unix)
  - Uses open formats that allows you to easily customize and extend the migration tasks
  - Exports database structures to SQL scripts
  - Exports data to text files (CSV, SQL INSERT statements, TAB-delimited, fixed length and other formats). Transfer of LOB data (images, binary data, formatted text) is completely supported
  - Provides you with a wizard-driven user interface to facilitate the migration.
  - Allows you to automate the migration process using the SQLWays command prompt tool
- Migration to Multiple Database Platforms

  - Provides you with the same concepts and methods to migrate databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL on different platforms
  - Supports not only the latest database versions, but many widespread versions as well
- High Performance

  - Uses high performance tools to import data (Oracle SQL Loader, IBM DB2 LOAD/IMPORT, SQL Server and Sybase BCP)
  - Data export and transformation modules written in C/C++

### Supported Databases

SQLWays supports migration from the following versions of databases:

Source Databases

- IBM DB2 UDB 8.1, 7.2, 6.1 and earlier, IBM DB2 S/390 and IBM DB2 AS/400
- Oracle 9i, 8i, 8.0.x, 7.x and earlier
- Microsoft SQL Server 2000, 7.0 and 6.5
- Sybase Adaptive Server 12, 11, 7 and earlier, Sybase SQL Anywhere 5.5 and earlier
- Informix 9.3, 7.3 and earlier
- MySQL 4.0.x, 3.23 and earlier
- Pervasive.SQL v8, 2000 and 7
- Microsoft Access 2000, 97, 95 and 2.0
- dBase, FoxPro, Excel, Paradox, Interbase, Gupta SQLBase and any other database accessible using the ODBC interface.

SQLWays supports migration to the following versions of databases:

Target Databases

- IBM DB2 UDB 8.1, 7.2 and 6.1
- Oracle 9i, 8i and 8.0.x
- Microsoft SQL Server 2000, 7.0 and 6.5
- Sybase Adaptive Server 12, 11
- MySQL 4.0.x and 3.23
- Pervasive.SQL v8

### SQLWays Standard, SQLWays Pro and SQLWays Enterprise Editions

There are differences between SQLWays Standard, SQLWays Pro and SQLWays Enterprise Editions.

Note. Limitations for each SQLWays Edition are effective within a database migration project.

SQLWays Standard Edition

- Up to 100 tables
- Unlimited number of rows per each table
- Views, constraints and indexes
- Up to 20 stored procedures and functions
- Up to 20 triggers

SQLWays Pro Edition

- Up to 300 tables
- Unlimited number of rows per each table
- Views, constraints and indexes
- Up to 100 stored procedures and functions
- Up to 100 triggers

SQLWays Enterprise Edition

- Unlimited number of tables
- Unlimited number of rows per each table
- Views, constraints and indexes
- Unlimited number of stored procedures and functions
- Unlimited number of triggers

[Table of Contents]
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.