DBSync for Oracle & MSSQL is a reliable bi-directional database migration tool which allows you to synchronize and convert from:
-Oracle to MSSQL
-Oracle to Oracle
-MSSQL to Oracle
-MSSQL to MSSQL
Synchronize and convert databases from Oracle to MS SQL or from MS SQL to Oracle rapidly and reliably! Operate with a whole database or select only needed tables, fields, indexes and foreign keys to proceed!
Reach the desired result by simply configuring of several options through Wizard interface or in command line mode! DBSync for Oracle & MS SQL is also applicable for MS SQL database synchronization and migration to another MS SQL database or even to another MS SQL server.
Moreover, DBSync for Oracle & MS SQL is quite well for Oracle database synchronizing and migration to another Oracle database or to another Oracle Server.
-Primary keys and Indexes support;
-Foreign key (relations) support;
-Insert-synchronization, Update-synchronization and Drop-synchronization available;
-Database objects (tables, fields, indexes and foreign keys) remapping;
-Oracle Server version 10.0 and higher support;
-ODBC Oracle and Oracle client are not required;
-Unicode support, all possible encoding support;
-Advanced customization options:
- partial selection for database objects to be converted.
- database objects (tables, fields, indexes) renaming before conversion.
- detection of possible conversion errors at customization stage.
-Sessions support - all your settings can be saved and restored then;
-Ability to select TCP/IP, PIPE, IPX/SPX communications protocols;
-BINARY` conversion support;
-Interactive (GUI) mode / command line mode;
-Feature to replace symbols in names of tables and fields (which are required not to be used as they are the symbols reserved for MS SQL internal purposes) with a substitute symbol;
-Automation of the conversion process with built-in scheduler;
-Data mapping - simple data types' assignment for a destination database to match one data type to its closest equivalent in the target fields;
-Ability to select table types when copying data to MS SQL;
-1-year free upgrades.