## SQLWays Readme

##### Version 3.7

This document contains the following topics:

- Introduction
- Documentation Notes
- Supported Databases
- Installation
- What's New
- How to Order
- Technical Support
- License Agreement
- Useful Links

### Introduction

SQLWays is a leading-edge migration tool that ensures easy and quick transfer of database structures and data between IBM DB2, Oracle, Microsoft SQL Server, Sybase, MySQL, Pervasive SQL and other databases.

Being powerful and functionality rich, SQLWays can convert all table and column properties, views, triggers, stored procedures and functions. It possesses such features as specifying local data type mapping for each table and global type mapping for all tables, providing enhanced data type mapping taking into account different maximum lengths and properties of compatible data types, resolving reserved word conflicts and problems with identifiers and renaming each database object and column.

Being especially developed to ensure a flexible and open migration process, SQLWays has the following advantages:

- Using export/import migration architecture that provides users with the most flexible capabilities for managing the migration process
- Allowing you to perform export on one system and import on another system and platform (Windows or Unix)
- Using open formats that make possible easy customization and extension of migration tasks
- Exporting database structures to SQL scripts
- Exporting 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
- Providing you with a wizard-driven user interface to facilitate the migration
- Allowing you to automate the migration process using the SQLWays command line tool.

Capable of performing migration to multiple database platforms, SQLWays makes it possible to migrate databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL on different platforms and supports a variety of database versions, not being limited to the latest versions only.

Effectively applying database native tools for the import of data, such as Oracle SQL Loader, IBM DB2 LOAD/IMPORT, SQL Server and Sybase BCP, and using the data export and transformation modules written in C/C++, SQLWays has proved to be very efficient and high-performance.

### Documentation Notes

To read about the migration process and to familiarize yourself with the SQLWays User Guide, please consult the Product Documentation included into the installation package and available on the Ispirer Systems website at http://www.ispirer.com/doc .

For more information about SQLWays: its key benefits, history and new releases, as well as about its developers and the services that they render, please visits the website of Ispirer Systems at http://www.ispirer.com .

### Supported Databases

SQLWays supports migration from the following versions of databases:

Supported Source databases
Database Product | Version
--- | ---
IBM DB2 for Linux, Unix and Windows | 8.1, 7.2, 6.1 and earlier
IBM DB2 for z/OS and OS/390 | 7.1, 6.1, 5.2, 5.1 and earlier
IBM DB2 for iSeries and AS/400 | V5R2, V5R1, V4R5 and earlier
Oracle | 9i, 8i, 8.0.x and 7.x
Microsoft SQL Server | 2000, 7.0 and 6.5
Sybase Adaptive Server Enterprise | 12.5.1, 12.5, 12.0, 11.x and earlier
Sybase Adaptive Server Anywhere, Sybase SQL Anywhere | 9.0, 8.0.x, 7.0.x, 6.0.x, 5.5 and 5.0
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 ODBC-compliant database | any version

SQLWays supports migration from the following versions of databases:

Supported Target Databases
Database Product | Version
--- | ---
IBM DB2 for Linux, Unix and Windows | 8.1, 7.2 and 6.1
IBM DB2 for z/OS and OS/390 | 7.1, 6.1, 5.2, 5.1
IBM DB2 for iSeries and AS/400 | V5R2, V5R1, V4R5
Oracle | 9i, 8i and 8.0.x
Microsoft SQL Server | 2000, 7.0 and 6.5
Sybase Adaptive Server Enterprise | 12.5.1, 12.5, 12.0, 11.x
MySQL | 4.0.x and 3.23
Pervasive.SQL | v8

### Installation

> #### Where to Install

> SQLWays is not to be necessarily installed on the same computer with either target or source database, but can be installed on any computer, which meets the software and hardware requirements.

> In order to provide access to each database available on the computer that runs SQLWays, you should install client software for the applied databases.

> #### Software Requirements

> - Operating System: Windows 98, Windows ME, Windows NT 4.0, Windows 2000 and Windows XP.
> - Database client software.
> - ODBC-driver (for source databases only).

> #### Hardware Requirements

> Hardware Requirements
> Computer | Intel® or compatible Pentium 166 MHz or higher
> Memory | At least 20 MB of free memory (more is recommended)
> Hard disk space | At least 20 MB of free space in the installation location
> Monitor | VGA or higher resolution 800x600 or higher resolution

> #### Hard disk space

> At least 20 MB of free space in the installation location for SQLWays (additional space required for export files, its volume defined by the volume of the information exported from the source database).

> #### Ensure administrator-level rights

> You must have administrator rights to install SQLWays on a Windows Operating System.

> #### Verify Compatibility of Vendor Databases

> Check the chapter Supported Databases to ensure that the version of SQLWays due to be installed supports the database you are going to migrate.

### What's New

To read about the major product updates, please see What's New .

To review all the product changes, see Changes in SQLWays .

### How to Order

> Each licensed copy of the software may either be used by a single person who uses the software personally on one or more computers, or installed on a single workstation used nonsimultaneously by multiple people, but not both.

> For Commercial Use by system integrators, consultants, VARs, ISVs, resellers, developers, service providers or IT professionals who provide solutions based on the software to third parties, a license is required for each project in which the software applied (discounts provided for partners).

> Customers receive free upgrades for one year. For more information, see SQLWays License Agreement

> #### US Sales Office

> Ordering Options - Credit Card, Fax Ordering, Postal Mail, Phone and Purchase Order

> US and Canada (Toll-Free Order Phone Number): 1-877-734-7638

> US Toll-Free Fax Number : 1-800-886-6030

> International Order Phone Number: +1-770-319-2718

> International Fax Number : 1-208-279-3837 (UK Customers can fax to (0870)132-2485)

> RegSoft.com Inc. 9625 West 76th Street, Suite 150 Eden Prairie, MN 55344

> Payments accepted in US Dollars.

> #### European Sales Office

> Ordering Options - Credit Card, Fax Ordering, Check, Wire Transfers, Phone and Purchase Order

> Languages - English, German, French, Italian, Spanish and Portuguese

> If you have any questions regarding the order and payment process or special transactions, please visit Customer Care Center

> #### Germany

> Tel.: +49.221.31088.20

> Fax: +49.221.31088.29

> share-it! - element 5 AG Vogelsanger Str. 78 50823 Cologne, Germany

> Payments accepted in Euro, US Dollars, Pounds Sterling, Australian Dollars, Japanese Yen, Canadian Dollars, or Swiss Francs.

> Please visit our site at http://www.ispirer.com/order/ for more information.

### Technical Support

Technical support is available via email from http://www.ispirer.com/support . You may either send an email to Ispirer Systems technical team at support@ispirer.com or post your message in the special online form available on the website.

The specialists of Ispirer Systems approach each individual case with maximum care and do their best to find the appropriate solution within the shortest possible time.

### License Agreement

To familiarize yourself with the SQLWays licensing terms, please read the License Agreement .

### Useful Links

- To find more information about Ispirer Systems product, see:
  http://www.ispirer.com/products/

- For comprehensive details about the product, see Online Documentation:
  http://www.ispirer.com/doc/

- To review distinguishing features of SQLWays, see Product Overview (PDF):
  http://www.ispirer.com/doc/product_overview.pdf

Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays™ www.ispirer.com.