SQLWays is permanently upgraded by its developers. The major features of the latest version SQLWays 3.7 include:
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. 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.
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.
- Transfer of spatial data
Copyright © 1999-2003 Ispirer Systems. All Rights Reserved.
SQLWays
www.ispirer.com.