DBSync for Oracle and MS SQL is a database synchronization tool
which performs two-way conversion and synchronization from Oracle
databases to MS SQL server and from MS SQL to Oracle. The tool is
also applicable for MS SQL database replication to another MS SQL
database and is quite adept at copying a Oracle database to
another Oracle database.
DBSync for Oracle and MS SQL provides the bulk of functional
capabilities such as interactive (GUI) mode/command line mode,
savable sessions, insert, update and drop synchronization types
included, task planner scheduling, data filtering, preverification
of possible conversion errors, etc.
You can convert and synchronize Oracle with MS SQL or MS SQL with
Oracle simply by configuring several options and by making some
sync customizations through a Wizard interface or in command line
mode. Command line parameters added to a scheduling function enables
you to automatically synchronize or convert data regularly without
user input and supplementary settings.
DBSync for Oracle and MS SQL provides you with the ability to
manipulate synchronization preferences on Customization stage
exactly according to your needs.
Filtering data during conversion allows users to retrieve only
specific data for converted tables according to defined filtering
criteria. Filters give you more control on the data migration process.
Possible synchronization errors can be detected before the
conversion process gets started. The tool displays errors and
potential problems with your table objects beforehand.
Recent Changes: - Oracle Server version 10.0 and higher support;
- ODBC Oracle and Oracle client are not required;
- Foreign keys (relations) support;
- Automatic synchronization process with built-in scheduler;
- Insert, Update and Drop sync
- Sessions support;
- Unicode and Binary data types support added.