Full Description:
DatabaseBridge is a powerful cross-DBMS data migration, data comparison and distributed query tool that also performs validation of flat data and acts as a convenient multi-DBMS browser. It is designed to work in a cross-DBMS, multiple data source environment and to serve a broad range of relational/non-relational data sources. It has exceptional data transfer speed. A cross-DBMS data transfer job of a million records can be completed in minutes. This tool allows you to copy whole databases or selected tables, including structure, data and indexes, from one DBMS to another at high speeds. It will also transfer BLOB/CLOB data between databases. BLOB/CLOB image sound, movie clips etc are viewable from the DatabaseBridge interface. It can compare two tables from different DBMS and show their data differences. After a data comparison, you can use database bridge to transfer data, to relocate data (move data out of one database into the other), to delete data differences for synchronization or to delete data in common for redundancy removal. It can serve as a multiple database browser for you to view database structure and access data for numerous databases of different DBMS (and flat data sources) simultaneously. DatabaseBridge also performs regular, or distributed queries which access data from different databases and makes cross-DBMS table joins. For example, you can fetch data from one DBMS and insert it into another DBMS with a single SQL statement. DatabaseBridge works with any ODBC compliant database which includes all the mainstream databases such as ORACLE, SQL server, DB2, Sybase, Access, etc. In addition, DatabaseBridge works with flat data sources such as text file based table or HTML based table, or EXCEL flat database table, etc. Particularly, DatabaseBridge provides a flat data validation tool to check data integrity, including checks on uniqueness, checks on relations similar to PK-FK, checks on various kinds of user defined rules.