## SQLWays Readme

##### Version 3.8

This document contains the following topics:

- Introduction
- Documentation Notes
- Supported Databases
- Installation
- What's New
- How to Order
- Evaluation and Switching Over to Full Product Version
- Technical Support
- License Agreement
- Useful Links

### Introduction

SQLWays is a leading-edge database 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.

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

- Transfers data including LOB (images, binary data, formatted text) and Spatial (GIS) data and converts tables (default values, null and identity properties, check and unique constraints, primary and foreign keys, comments), indexes, views, triggers, stored procedures and functions
- Offers powerful capabilities for data type conversion that can be specified on the global level applicable for all tables and on the local level, for each table individually, taking into account different maximum length limits of identical data types in different databases.
- Resolves reserved word and identifier conflicts
- Makes possible renaming each database object and table column
- Uses the export/import process that provides the most flexible capabilities for managing migration
- Allows migrating between geographically divided databases
- Uses open formats facilitating customization and extension of migration tasks
- Exports database structures to SQL scripts and data to ASCII text files (CSV, SQL INSERT statements, TAB-delimited, fixed length and other formats).
- Provides you with a wizard-driven user interface that makes migration easy
- Allows you to automate migration process with the help of the SQLWays command line tool
- Makes possible migration of databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL on different platforms
- Supports a variety of database versions, not being limited to the latest versions only
- Uses high-performance native database tools to import data
- Data export and transformation modules written in C/C++

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/products_onlinedoc/ .

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.2, 8.1, 7.2, 7.1, 7.0, 6.1 and earlier
IBM DB2 for z/OS, OS/390 and MVS | 8.1, 7.1, 6.1, 5.2, 5.1 and 4.1
IBM DB2 for iSeries and AS/400 | V5R3, V5R2, V5R1, V4R5, V4R4 and earlier
Oracle | 10g, 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.4, 9.3, 9.2, 9.1, 7.3, 7.2, 7.1 and earlier
MySQL | 5.0, 4.0.x, 3.23 and earlier
PostgreSQL | 7.x and 6.x
SAP DB | 7.4, 7.3 and earlier
Pervasive.SQL | v8, 2000 and 7
Microsoft Access | 2000, 97, 95 and 2.0
Interbase, Firebird | 7.1, 6.x, 5.x and 4.x
Lotus Notes | 6, 5 and earlier
dBase, FoxPro, Excel, Paradox, Gupta SQLBase, Clipper 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.2, 8.1, 7.2, 7.1, 7.0, 6.1 and earlier
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, V4R4
Oracle | 10g, 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, Windows XP and Windows Server 2003.
> - 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.

### Evaluation and Switching Over to Full Product Version

Before you enter the license information, the software operates in the evaluation mode.

During evaluation, SQLWays converts all tables, stored procedures and other database objects, exports all rows except the first one in each table and converts all lines in each stored procedure, trigger and function. The only evaluation restriction is adding _EVAL sign to each column and variable name.

As soon as you purchase the software, you will be provided with your licensing information (name and registration number).

Run SQLWays Wizard, click Enter License and enter this license information. After that the software will remove all limitations and start working as a full version.

### 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/products_onlinedoc/

- To review distinguishing features of the product, see SQLWays White Papers (PDF):
  http://www.ispirer.com/doc/sqlways_whitepaper.pdf

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