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++.
Limitations in downloadable version:
SQLWAYS_EVAL# is added to some comments and constant strings.