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 Seperated Value) files into databases
Database Connectivity:
Supports connection to Databases using JDBC drivers. Tool bundles default drivers for easy connectivity
Supports connection to SQL Server through Windows Authentication
Migration support:
Migrates Tables, Indexes, Views, Constraints along with data.
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.
Migrates data from Excel and CSV (Comma Separated Value) files into databases.
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 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 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.
Handles the migration of auto increment columns appropriately
User defined DB2 Schema objects can be migrated to any database
Oracle spatial database can be migrated to DB2 spatial database
Provides option to save the generated target CREATE statements(DDL) in a file
Provides option to delete existing objects before the new objects are are migrated from the source database
Provides option to migrate both schema and data, or just data, or just schema alone
Back's-up tables in target database before migration
Transformation support:
Option to choose only the necessary columns to be migrated in a table
Option to change the table and column names in the target database during migration
Option to map columns in source database to appropriate columns in destination database
Option to change the datatype of columns in a table and or across all the tables
Option to migrate and transform data using SQL SELECT queries.
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.
Option to modify / translate the data such as generating a new calculated value from existing data using SQL SELECT queries.
GUI:
Provides simple, easy to use, wizard driven GUI for migration
Configurable options to choose the migration of tables, indexes, views, and data.
Provides detailed and summary migration reports.
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
Supports Project driven approach for organizing the migrations for better management.
Summary view highlighting the migration
Third party JDBC drivers can also be loaded for database connectivity
Feedback option is provided in all the screens to report feedback/issues instantly