Cross-Database Comparator Pro is a single comprehensive and integrated enterprise working environment to compare database data and structure across any database types. DBBalance products take the “pain” out of cross database data and structure comparison shortening and simplifying processes.
Cross-Database Comparator Pro 6.0 includes comparison reports in XML and HTML formats. These reports can simply be integrated into any reporting or process control system.
DBBalance solutions include a wide spectrum of predefined settings and rules (strategy) for comparison and replication. There is no need to configure relations between different data-types and objects between different database types. Simply select the objects you wish to compare and you?re done. You can always control the settings and define your own rules, if your process requires any special definitions.
Using Cross-Database Comparator Pro you can use mass compare in “Batch” mode just select all the objects you wish to compare to create a comparison strategy and execute it immediately or in scheduling mode.
Using Cross-Database Comparator Pro you can compare any set of objects between one database type and another.
Compare, Synchronize:
Compare:
1. table/view columns properties:
2. column name
3. data type
4. column length
5. column precision
6. column scale
7. column NULL allow
8. column default value
9. primary key properties:
10. primary key name
11. primary key column name
12. index properties:
13. index name
14. column name
15. index owner
16. unique
17. sort type
18. foreign key properties:
19. foreign key name
20. primary table name
21. primary column name
22. foreign table name
23. foreign column name
24. update rule
25. delete rule
26. stored procedure (for different versions of database of same vendor):
27. stored procedure name
28. stored procedure body
29. table/view data:
30. all or selected table/view data
31. batch comparison:
32. including comparison of the table structures, primary keys, indexes, foreign keys, data
33. scheduling is available
Comparison results can be reported to the screen or saved in XML/HTML files.
Synchronize:
1. Manual synchronization
2. columns properties
3. primary key properties
4. index properties
5. foreign key properties
6. table/view data
7. Create the strategy for full table or partial list of objects
The license of this software is Free Trial Software, the price is $499, you can free download and get a free trial.
Cross-Database Comparator Lite 6.0 Description
Cross-Database Comparator Lite is a single integrated working environment to compare database data and structure across any database types. DBBalanceâÂ?s products take the “pain” out of cross database data and structure comparison shortening and simplifying processes.
Cross-Database Comparator Lite includes comparison reports in XML and HTML formats. These reports can simply be integrated into any reporting or process control system.
DBBalanceâ�s solutions include a wide spectrum of predefined settings and rules (strategy) for comparison. There is no need to configure relations between different data-types and objects between different database types. Simply select the objects you wish to compare and youâ�re done.
Description
Cross-Database Comparator Pro is a single comprehensive and integrated enterprise working environment to compare database data and structure across any database types. DBBalance products take the “pain” out of cross database data and structure comparison shortening and simplifying processes.
Cross-Database Comparator Pro 6.0 includes comparison reports in XML and HTML formats. These reports can simply be integrated into any reporting or process control system.
DBBalance solutions include a wide spectrum of predefined settings and rules (strategy) for comparison and replication. There is no need to configure relations between different data-types and objects between different database types. Simply select the objects you wish to compare and youre done. You can always control the settings and define your own rules, if your process requires any special definitions.
Using Cross-Database Comparator Pro you can use mass compare in “Batch” mode just select all the objects you wish to compare to create a comparison strategy and execute it immediately or in scheduling mode.
Using Cross-Database Comparator Pro you can compare any set of objects between one database type and another.
Compare, Synchronize:
Compare:
table/view columns properties:
column name
data type
column length
column precision
column scale
column NULL allow
column default value
primary key properties:
primary key name
primary key column name
index properties:
index name
column name
index owner
unique
sort type
foreign key properties:
foreign key name
primary table name
primary column name
foreign table name
foreign column name
update rule
delete rule
stored procedure (for different versions of database of same vendor):
stored procedure name
stored procedure body
table/view data:
all or selected table/view data
batch comparison:
including comparison of the table structures, primary keys, indexes, foreign keys, data
scheduling is available
Comparison results can be reported to the screen or saved in XML/HTML files.
Synchronize:
Manual synchronization
columns properties
primary key properties
index properties
foreign key properties
table/view data
Create the strategy for full table or partial list of objects
Save time by automatically comparing and synchronizing database schemas and content.
Eliminate mistakes by finding and migrating data and schema changes from development database to test or production database.
Find and fix errors caused by differences between databases.
Speed up the deployment of new database schema updates.
Generate SQL scripts to update one database to match the schema to another.
Generate SQL scripts to update one database with the contents of another.
Copy lookup data from development databases to staging or production.
Quickly fix problems by restoring damaged or missing data to a single row.
Convert database without fearing that your target database will be unstable or have some differences between data types.
Update or export the old database to the new format
Import or re-create the database under the new version
Share your data from the desktop database to a multiuser on-line DBMS in the best and most efficient way.