SwisSQL Data Migration Tool - Features Overview

Supported Database:

1. Supports migration/transfer of schema and data across Oracle, IBM DB2, SQL Server, Sybase, MySQL MaxDB, MySQL, PostgreSQL and MS Access databases
2. Migration of data from Excel and CSV (Comma Seperated Value) files into databases

Database Connectivity:

1. Supports connection to Databases using JDBC drivers. Tool bundles default drivers for easy connectivity
2. Supports connection to SQL Server through Windows Authentication

Migration support:

1. Migrates Tables, Indexes, Views, Constraints along with data.
2. Maintains the relationship between the tables as in the source database. Identifies dependencies between master and child tables and also orders the tables with primary key and foreign key.
3. Migrates data from Excel and CSV (Comma Separated Value) files into databases.
4. Support for migration and transformation of data using SQL SELECT queries.
5. 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.
6. Criteria based data migration (data subsetting) is supported when migrating from Oracle, SQL Server, MySQL 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.
7. Handles the migration of auto increment columns appropriately
8. User defined DB2 Schema objects can be migrated to any database
9. Oracle spatial database can be migrated to DB2 spatial database
10. Provides option to save the generated target CREATE statements(DDL) in a file
11. Provides option to delete existing objects before the new objects are are migrated from the source database
12. Provides option to migrate both schema and data, or just data, or just schema alone
13. Back's-up tables in target database before migration

Transformation support:

1. Option to choose only the necessary columns to be migrated in a table
2. Option to change the table and column names in the target database during migration
3. Option to map columns in source database to appropriate columns in destination database
4. Option to change the datatype of columns in a table and or across all the tables
5. Option to migrate and transform data using SQL SELECT queries.
6. Option to join together data from multiple source tables and migrate to target database . Supports one-to-many, many-to-one and many-to-many mapping of source and target tables using SQL SELECT queries.
7. Option to modify / translate the data such as generating a new calculated value from existing data using SQL SELECT queries.

GUI:

1. Provides simple, easy to use, wizard driven GUI for migration
2. Configurable options to choose the migration of tables, indexes, views, and data. 
3. Provides detailed and summary migration reports. 
4. The integrity of the data (along with the database objects) migrated can be verified using a unique tool named "Database Migration Verifier". Currently verification is supported only for SQL Server to Oracle migration
5. Supports Project driven approach for organizing the migrations for better management. 
6. Summary view highlighting the migration 
7. Third party JDBC drivers can also be loaded for database connectivity
8. Feedback option is provided in all the screens to report feedback/issues instantly