## SQLWays What's New

> SQLWays is permanently upgraded by its developers. The major features of the latest version SQLWays 3.7 include:

> ###
> - Improved Conversion of Stored Procedures

> In the new version, the conversion of SQL and flow-of-control statements, queries, declarations, assignments and other SQL language elements between Oracle, Microsoft SQL Server, IBM DB2, Sybase and Pervasive.SQL stored procedures is improved.

> ###
> - Advanced Data Type Conversion

> The new version offers unique and powerful capabilities for the data type conversion that can be specified on the global level applicable for all tables and on the local level for each table individually.
> SQLWays takes into account that identical data types may have different maximum length limits, divides such data types by ranges and converts each range to the most compatible data type.

> For example, in SQL Server the CHAR data type has the maximum length 8000 while in Oracle it is 2000. When converting the SQL Server CHAR type to Oracle, it is converted into CHAR if the actual column length does not exceed 2000 or VARCHAR2 if it does not exceed 4000. Otherwise, it is converted to CLOB.

> ###
> - Transfer of spatial data

> SQLWays is capable of transferring spatial data (e.g. geographic maps) used in Geographic Information Systems (GIS) applications between Oracle 9i databases.To become familiarized with all the product changes, see changes.txt file supplied with the install package.

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