SQLWays

SQLWays ™ is an innovative database migration product that easily converts all major databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase, MySQL. and other relational DataBase

Being a complete migration solution, SQLWays automates the entire migration process converting data, database objects, constraints and business logic. Highly flexible, it can be adapted to the unique requirements of various database conversion projects.

Supporting a wide variety of databases and using high performance technologies especially adapted for working with large volumes of data, SQLWays is an ideal choice for companies dealing with multiple databases

Key Benefits:

Complete, Functionality-Rich and Adaptive

  • Transfers data including LOB (images, binary data, formatted text) and Spatial (GIS) data and converts tables (default values, null and identity properties, check and unique constraints, primary and foreign keys, comments), indexes, views, triggers, stored procedures and functions
  • Offers powerful capabilities for data type conversion that can be specified on the global level applicable for all tables and on the local level, for each table individually, taking into account different maximum length limits of identical data types in different databases.
  • Resolves reserved word and identifier conflicts
  • Makes possible renaming of each database object and table column

Flexible, Open and Extensible Migration Process

  • Uses the export/import process that provides the most flexible capabilities for managing migration
  • Allows migrating between geographically divided databases
  • Uses open formats facilitating customization and extension of migration tasks
  • Exports database structures to SQL scripts and data to ASCII 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

Migration to Multiple Database Platforms

  • Makes possible migration of databases to IBM DB2, Oracle, Microsoft SQL Server, Sybase and MySQL on different platforms
  • Supports a variety of database versions, not being limited to the latest versions only

High Performance

  • Uses high-performance native database tools to import data
  • Data export and transformation modules written in C/C++

To learn more about the advantages of using SQLWays for ensuring quick and smooth migration, read our SQLWays White Paper


Supported Source Databases:
  • IBM DB2 for Linux, Unix and Windows 8.2, 8.1, 7.2, 7.1, 7.0, 6.1 and earlier
  • IBM DB2 for z/OS and OS/390, MVS 8.1, 7.1, 6.1, 5.2, 5.1 and 4.1
  • IBM DB2 for iSeries and AS/400 V5R3, V5R2, V5R1, V4R5, V4R4 and earlier
  • Oracle 10g, 9i, 8i, 8.0.x and 7.x
  • Microsoft SQL Server 2005, 2000, 7.0 and 6.5
  • Sybase Adaptive Server Enterprise (ASE) 12.5.1, 12.5, 12.0, 11.x and earlier
  • Sybase Adaptive Server Anywhere (ASA), Sybase SQL Anywhere 9.0, 8.0.x, 7.0.x, 6.0.x, 5.5 and 5.0
  • Sybase IQ 12.x
  • Informix Dynamic Server (IDS) 10, 9.4, 9.3, 9.2, 9.1, 7.3, 7.2, 7.1 and earlier
  • Informix Standard Engine (SE) 7.x, 5.x, 4.x and earlier
  • MySQL 5.x, 4.x, 3.23 and earlier
  • PostgreSQL 8.x, 7.x and 6.x
  • Progress 9.x and 8.x
  • SAP DB 7.4, 7.3 and earlier
  • Pervasive.SQL v8, 2000 and 7
  • Microsoft Access 2003, 2000, 97, 95 and 2.0
  • Interbase, Firebird 7.1, 6.x, 5.x and 4.x
  • Lotus Notes 6, 5 and earlier
  • dBase, FoxPro, Excel, Paradox, Gupta SQLBase, Clipper and any other ODBC-compliant database
Supported Target Databases:
  • IBM DB2 for Linux, Unix and Windows 8.2, 8.1, 7.2, 7.1, 7.0, 6.1 and earlier
  • IBM DB2 for z/OS and OS/390 8.1, 7.1, 6.1, 5.2, 5.1
  • IBM DB2 for iSeries and AS/400 V5R3, V5R2, V5R1, V4R5, V4R4
  • Oracle 10g, 9i, 8i and 8.0.x
  • Microsoft SQL Server 2005, 2000, 7.0 and 6.5
  • MySQL 5.x, 4.x and 3.23
  • PostgreSQL 8.0 and 7.x
  • Sybase Adaptive Server Enterprise 12.5.1, 12.5, 12.0, 11.x
  • Sybase IQ 12.x
  • Informix Dynamic Server (IDS) 10, 9.4, 9.3, 9.2, 9.1, 7.3, 7.2, 7.1 and earlier
  • Pervasive.SQL v8
Financial Services and Insurance
  • Citygroup
  • American Express
  • JP Morgan Fleming Asset Management
  • Allianz
  • PrimeCredit Limited
  • Investors Title Insurance Company
  • APS Bank Ltd
  • AXA Investment Managers Ltd
 Information Technology
  • EDS
  • Deloitte & Touche
  • CAP Gemini
  • AMD
  • Fujitsu
  • Thomson
  • Context Integration
  • MICROS Systems, Inc.
  • eGlobal
  • CMG Finance GmbH
  • Kana Software, Inc.
  • Infoglide Software
  • Pegasystems Inc.
  • DAZ Systems Inc.
  • OM Technology Energy Systems AS
  • CB Technologies
  • Intelligent Information Systems, Inc.
  • DWL Inc.
  • Campbell Lee Computer Services
  • nCode International
  • Bentley Systems, Inc.
 Telecommunications
  • Genesys Telecommunications Laboratories, Inc.
  • Conversent Communications
  • Sentrio Technologies
  • SpeechWorks Technology
  • Henry Wurst Inc.
 Transportation
  • The American Bureau of Shipping (ABS)
  • Viking Freight (FedEx Freight West)
Energy and Manufacturing
  • Shell
  • ChevronTexaco Corp.
  • Lockheed Martin
  • Neuralog, Inc.
 Consumer and Retail
  • Mills Corp.
Health Care
  • IPC - The Hospitalist Company
  • The American Academy of Ophthalmology
  • Becton, Dickinson and Company
  • Source Medical Solutions Inc.
  • Roche Bioscience
  • Elmhurst Memorial Healthcare
  • GE Medical Systems
 Education
  • Ohio State University
  • Ireland Department of Education and Science
  • Limburgs Universitair Centrum

 

 

 

 

 

 

 

 

 

 

 

SQLWays™3.9

Solutions
  • Migrating database schema and data between databases

  • Converting a whole database including business logic to another database platform

  • Converting offline databases (SQL scripts, dump files etc.)

  • Converting database API and applications

  • Transferring data between databases on a time-interval basis

  • Migrating between databases, simultaneous connection to which cannot be set up (e.g. geographically divided databases)

  • Migrating/Upgrading large critical databases with zero downtime (migration and replication)

  • Synchronizing databases after migration (during phase out period for old system)

  • Database-type independent Backup/Restore functinality

  • Exporting data to ASCII files and schema to SQL scripts

  • Replicating updated data

 


SQLWays runs on Microsoft Windows 98/ME/NT 4.0/2000/XP/2003

SQLWays supports migration from/to databases running on Windows, Linux, Solaris, AIX, HP-UX, AS/400, iSeries, OS/390 and z/OS