Cross-Database Studio is capable to work across ANY databases, where there is ODBC driver. Usually ODBC drivers delivered together with DBMS by the vendor, however there are companies developing high-quality ODBC drivers standalone.

Our Q&A team constantly tests Cross-Database products work against different DBMS types of different vendors. Below is a list of only few DBMS which Cross-Database Studio was certified for:

• MICROSOFT SQL SERVER
• ORACLE
• IBM DB2
• MYSQL
• POSTGRESQL
• SYBASE
• INFORMIX
• INTERBASE
• INTERSYSTEM CACHE
• SQLBASE
• SQLITE
• TERADATA
• FIREBIRD
• 4D
• BTRIEVE
• DBASE
• FILEMAKER PRO
• FOX PRO
• LOTUS NOTES
• MICROSOFT ACCESS
• MICROSOFT EXCEL
• PARADOX
• TEXT
• XML

The software is able to compare either pair of isolated schema objects or groups of the objects of two schemas or all the objects of two schemas.
The list below shows the objects of database schema, and their properties that can be compared by the software

• table/view columns:
• column name
• data type
• column length
• column precision
• column scale
• column NULL allow
• column default value
• primary keys:
• primary key name
• primary key column name
• table indices:
• index name
• column name
• index owner
• unique
• sort type
• foreign keys:
• foreign key name
• primary table name
• primary column name
• foreign table name
• foreign column name
• update rule
• delete rule
• stored procedures (for databases of same type ):
• stored procedure name
• stored procedure body

The software is able to compare :

• the data stored in database tables
• the data represented by database views
• datasets returned by SQL queries of any complexity

The program supports comparison of any data type, including all binary data types - LOB, BLOB etc.
The wide spectrum of data comparison options and set specially developed features allows user to build and realize comparison strategies of any complexity: the software allows even comparison of differently structured data.

Provides widest spectrum of customizable settings of comparison, synchronization and migration, satisfying most severe requirements

• Provides full access to the software functionality from command line
• Automates the comparison and synchronization of database schemas and data
• Allows scheduling of comparison, synchronization or migration tasks
• Allows to compare and synchronize multiple databases
• Allows to invoke any software functionality from a script, such as a batch script or VBScript, or by using the facilities provided by compiled languages such as VB, C++ and C#, Java

• Access to all registered reports via single unitized user interface, not depending on physical location of the report file.
• Automatic tracking of deleting/creating the report files, dynamic refresh of reports list.
• Opening a report in its original format or translation into another specified format
• Assigning and reassigning transformation rules for report of any format
• Tracking and logging important events being occured during software's work process.
• Convenient searching, filtering and viewing of the event journal.
• Detailed automatic monitoring of active jobs and their status.