Data and Schemas Comparison with Cross-Database Studio
Find differences in data, table structures, table indices, primary and foreign keys and stored procedures between databases of same or different type.
Cross-Database Studio allows comparing database schema elements and database content across different database types.
The Studio provides with a widest spectrum of predefined settings, rules, and features.
There is no need to configure relations between different data types and objects for comparison and replication between different database types.
Simply select the objects you wish to compare, and click you're done.
You can always control the settings and define your own rules, if your process requires any special
- Flexible configuration, intuitive and easy-to-use UI, reliable results.
- Concurrent connection to different types of databases
- Supports comparison of data and structure across databases deployed on different platforms (Windows Unix, Linux or Solaris ).
- Unified approach for comparison across different database types.
- Powerful unified report system, configurable reports
Database Comparison Features:
- Compare data and structure between databases of same or different types
- Supports comparison of schema and data across any ODBC compliant databases, including Oracle, IBM DB2, MS SQL Server, Sybase, MySQL MaxDB, MySQL, PostgreSQL, MS Access etc.
- Personal strategy definition for each component or for group of objects in single or batch mode
- Wide spectrum of predefined comparison rules and options
- Key independant data comparison. Compare data in tables without primary key or UNIQUE constraints with a custom comparison key
- Sophisticated reporting: powerful report system unifying work with all the reports generated by the software
- Generating reports practically in any desired file formats: HTML, CSV, MS Excel
- Possibility to configure detalization of the info displayed by generated reports
- Support comparison of SELECT queries result.
- Supports comparison of stored procedures if the source and target RDBMS are the same.
- Criteria based data comparison (data subsetting) is supported when comparing Oracle, SQL Server, MySQL, PostgreSQL and Sybase ASE to any database.
User can set the filter criteria for a table(s) based on which, only the rows matching the criteria (subset) will be compared.
How can Cross-Database Studio help you with Data and Schemas Comparison?