| |
|
|
| SQLWaysâ„¢ is a database migration product that migrates all major databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL. |
Description: SQLWays™ is an innovative database migration product that easily perform export (migrates all major databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL) on one system and import on another system and platform (Windows or Unix). It is an ideal choice for companies dealing with various migration projects. Being a complete migration solution, it automates the entire migration process and transfers data including LOB (images, binary data, formatted text) and Spatial (GIS) data. SQLWays converts tables (default values, null and identity properties, check and unique constraints, primary and foreign keys, comments), indexes, views, triggers, stored procedures and functions. Allows you to specify global data type mapping for all tables and local data type mapping for each table individually. Provides enhanced data type mapping taking into account different maximum lengths and properties of compatible data types in different databases. Resolves reserved word and identifier conflicts. Makes possible renaming each database object and column. SQLWays is highly flexible and adaptive and uses high performance data loading technologies. Uses migration process that provides the most flexible capabilities for managing migration. Uses open formats facilitating customization and extension of migration tasks. Exports database structures to SQL scripts. Exports data to 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. Supports a variety of database versions, not being limited to the latest versions only. Uses high-performance native database tools to import data (Oracle SQL Loader, IBM DB2 LOAD/IMPORT, SQL Server and Sybase BCP). Data export and transformation modules written in C/C++. | System Requirements: Windows 98, Windows ME, Windows NT 4.0, Windows 2000, Windows 2003 Server, Windows XP. Database client software. ODBC-driver (for source databases only). Intel® or compatible Pentium 166 MHz or higher. At least 20 MB of free memory (more is recommended) | Change Info: 1) 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, Pervasive.SQL and MySQL stored procedures is improved.
2) 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 compatible data types may have different maximum length limits, divides such data types by ranges and converts each range to the most compatible data type.
3) 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. | SQLWays 3.7 Download from ispirer.com |
| Similar software: | - DatabaseBridge 1.006 — DatabaseBridge is a powerful cross-DBMS data migration, data comparison and distributed query tool that also performs validation of flat data and is a multi-DBMS browser. A cross-DBMS data transfer of a million records can be completed in minutes
- Oracle-to-MySQL 3.1 — Oracle-to-MySQL is a program to move Oracle databases to MySQL server. All Oracle data types (except BFILE and MLSLABEL) and attributes are supported. The program has easy-to-use wizard style interface and works with all versions of MySQL server.
- ConversionTool 4.2.2 — Tool reengineers BTrieve databases and converts comprehensively Access databases into SQL Server preserving all table structure details, and supports the conversion of the views and procedures. Moreover, the tool supports solution of problems.
| Find all software similar on SQLWays 3.7 |
|