
SQLWays version 3.7

Copyright (C) 1999-2003 Ispirer Systems.
All Rights Reserved.

For a list of changes in this version see whatsnew.txt.
For the samples of using SQLWays see the SQLWays documentation.

DESCRIPTION 
-----------

  SQLWays is a powerful, flexible and high-performance database migration and 
data export tool.
  SQLWays transfers database definitions and data from various databases to 
Oracle, IBM DB2, Microsoft SQL Server, Sybase, MySQL and Pervasive.SQL.

  Supported Source Databases:

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

  Supported Target Databases:

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

  Migration Process:

  1. Export

  SQLWays exports data to flat files, extracts database definitions and generates
SQL scripts from the source database.

  2. Preparation for Import

  Exported files and scripts can be reviewed, modified and transferred to other
system to perform import.

  3. Import

  SQLWays imports database definitions and data to the target database using the
database native import-load tools.

  Features:

  - SQLWays extracts database definitions and generates SQL scripts for tables 
and indexes, primary and foreign keys, unique and check constraints, default
values, identity columns, views, triggers and stored procedures.

  - SQLWays provides the fastest way to import data since it uses
high-performance tools like Oracle SQL Loader, IBM DB2 LOAD, Microsoft SQL 
Server and Sybase BCP for importing.

  - This is a comprehensive command prompt tool. You can create various
scripts to automate your work. The tool allows you to create scripts for
regular data moving, loading into databases or data warehouses.

  - SQLWays can export data into text files (supported formats: CSV, TAB 
delimited, fixed length, SQL INSERT statements and XML).

  - You can specify any sequence of creating tables, constraints, importing 
data and creating indexes. You can specify the time of creating constraints -
before or after importing data. 

  - Transfer of LOBs (images, binary data, formatted text) is
completely supported.

  - Many features are available to adjust generating SQL scripts 
and exporting data.

  Please, visit SQLWays home page for details: http://www.ispirer.com/products/

MINIMAL SYSTEM REQUIREMENTS
---------------------------

  - Windows 95/98 or Windows NT/2000/XP

HOW TO INSTALL
--------------

  If you get SQLWays as a zipped archive, unzip it in a some program 
directory (for example, SQLWays). If you get a diskette, skip this step
- all of the files are on the diskette.
  The software doesn't require installation. You can immediately use it
when run SQLWays.exe file or SQLWaysWzd.exe.
  SQLWays is a command prompt utility and you need set parameters for use it.
Otherwise when launching SQLWays.exe without parameters by either the Windows
run line or by double clicking the application from Explorer a window opens
briefly and then closes. 
  See the SQLWays documentation for the exapmles of using SQLWays.

EVALUATION AGREEMENT
--------------------

  The trial version of the software may be used for evaluation purposes only 
for a period of no more than 31 days. If you want to continue use the software
you must register it (see license.txt and order.txt for details).
  There is a limitation in a trial version. First 7 rows are skipped.

TECHNICAL SUPPORT
-----------------

  Contact us: support@ispirer.com

  http://www.ispirer.com


