SwisSQL Data Migration SQL Migration Tools SwisSQL Console
SwisSQL API (Java Edition) Stored Procedure Migration Tools
SwisSQL SQL Server To Oracle
SwisSQL Sybase To Oracle
SwisSQL DB2 To Oracle
SwisSQL Sybase To SQL Server
SwisSQL DB2 To SQL Server
SwisSQL Oracle To SQL Server
SwisSQL Oracle To DB2
SwisSQL SQL Server To DB2
SwisSQL Sybase To DB2
SwisSQL Oracle to Sybase
Home
> Products > Data Migration
Tool
SwisSQL - Data Migration Tool 6.5
SwisSQL - End of Life Notice Thanks for your interest inSwisSQL
Regret to inform you that we have decided to discontinue any development and investments on this product to best align with our business goals and direction. Existing customers of SwisSQL can avail product support from us till their current support contract expires. For further queries, do email us at support@swissql.com and we'll be happy to assist you.
Migrate/Transfer/Copy/Transform Schema and Data across
Multiple Databases
SwisSQL offers a complete Data Migration Tool that helps the migration and transfer of database schemas and data across leading databases such as Oracle, IBM DB2, MS-SQL Server, Sybase, MySQL, PostgreSQL and MS Access. It offers an open, user-friendly, and extensible migration process ensuring reliability and data integrity.
Key Benefits:
Flexible, open and extensible migration process.
Rapid data migration across databases ensuring data integrity with no loss of data.
Restructure/Transform schema and data with ease during migration.
Migrate/Transfer data across databases deployed on different platforms (Windows or Unix or Linux).
Provides an uniform approach for migration across different databases.
Offers a unique mechanism to verify the migrated data using "Database Migration Verifier".
Easy to Install and Easy to Use tool with user friendly & intuitive GUI.
SwisSQL Data Migration Tool Features:
Supports migration/transfer of schema and data across Oracle, IBM DB2, SQL Server, Sybase, MySQL MaxDB, MySQL, PostgreSQL and MS Access databases.
Migration of data from Excel and CSV (Comma Separated Value) files into databases.
Migrates tables, indexes, constraints along with data.
Support for migration and transformation of data using SQL SELECT queries.
Generates scripts to perform data & schema migration in a command line mode (without GUI). Scripts can also be used for periodic scheduled migration.
Supports basic features for Schema and Data transformation during migration.
Supports migrating stored procedures, functions, triggers, if the source and target RDBMS are the same. Following migration combinations are supported currently: SQL Server to SQL Server, Oracle to Oracle, DB2 to DB2 and Sybase to Sybase.
Criteria based data migration (data subsetting) is supported when migrating from Oracle, SQL Server, MySQL, PostgreSQL and Sybase ASE to any database. User can set the filter criteria for a table(s) based on which, only the rows matching the criteria (subset) will be migrated. If criteria is set for a table, then its dependant tables will also be migrated based on its relationship.
Support for migration to CSV files and Insert SQL statements.
More Features >>
SQL
Query
Translator
SwisSQL
Console
Translates
SQL Queries from one database dialect
to another.
More
Info
Download
How can SwisSQL Data Migration tool help you?
Moving to new database: Create database, tables and copy corresponding data from one database to another (even across heterogeneous databases)
Upgrading to new version of the database: Move schema and data from one version of the database/application to another (Eg., SQL Server 2000 to SQL Server 2005)
Filtering Data (data subsetting): Migrate/Copy data based on simple as well as complex criteria. If criteria is set for table(s), then its dependant tables will also be migrated based on its relationship
Restructuring tables and data (transformation): Migrate table and data applying wide range of restructuring/transformations options. Options include, table and column name changes, datatype mapping, selecting specific columns, column mappings etc., that can be applied during migration
Adding new data to existing database: Copy or add new data to existing tables in a database
Supported
Database Versions
Source
Database
Target
Database
Oracle 8i, 9i, 10g and 11g
IBM DB2 UDB for Linux, Unix, and
Windows 7.1 and 8.x