SQLWays Readme

Version 3.7

This document contains the following topics:

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:

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

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


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