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 of specially developed features allow user to build and realize comparison strategies of any complexity: the software allows even comparison of differently structured data.

• Allows to synchronize either pair of isolated schema objects or groups of the objects of two schemas or all the objects of two schemas.
  
• Generate error-free synchronization scripts
• Saves the synchronization scripts for later use
• Migrates individual, a selection of, or all schema differences
• Allows to use sophisticated rules to selectively limit what to synchronize
• Maintans tables dependency so all the objects are scripted in the correct order for updates
• Fine-grained filtering of database objects and their properties
• Performs synchronization in safe mode preventing data loss when altering schema objects

• Supports data synchronization across any ODBC compliant databases.
• Maintains the referential integrity as in the source database.
• Synchronizes data of any types, including UNICODE text and all binary data types - LOB, BLOB etc.
• No limitation on table or database size
• Automatically recognizes data types of columns participating in synchronization session, allowing to synchronize data of different types.
• Supports data transformation using SQL SELECT queries.
• Powerful table/column mapping features, allowing data synchronization even if databases are structured differently
• Advanced filtering capabilities allowing partial data synchronization: synchronization of data subsets

The software allows migration of table/view (structure and/or data) based to data types conversion mechanism and custom defined fields list

• Supports migration/transfer of schema and data across any ODBC compliant databases.
• Maintains the referential integrity as in the source database.
• Allows to migrate tables, indexes, primary and foreign keys along with data.
• Automatically convert column data types on basis of built-in customizable conversion map
• Supports data transformation using SQL SELECT queries.
• Supports migrating stored procedures, if the source and target DBMS are the same.
• Filter criteria based data migration (migration of data subsets) is fully supported.

Provides set of powerful, specially designed features, providing different ways of the data merging, data splitting and data filtering.
The features enable to build and realize most complicated strategies of comparison, synchronization and migration

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.