Cross-Database Comparator Pro 5.0
With Cross-Database Comparator Pro you will be able to synchronize following database objects:
Database structure
Indexes
Primary keys
Foreign keys
Store Procedures
Table Data
The synchronization can be performed immediately after comparison, using GUI client as well as synchronization SQL script can be generated for further synchronization in off line or remotely mode.
Data synchronization has an additional modes allowing creating different comparison and synchronization strategies including:
The direction of synchronization;
The level of synchronization: INSERT, UPDATE and DELETE operations
Reaction during synchronization session on anticipated DBMS failures.
Set of table and their synchronization order.
Time scheduling setting for data synchronization operation.
During synchronization the program automatically defines data types of column participating in synchronization session. This means that the data in column of NUMERIC type can be synchronized to a column of CHAR type. Using `Virtual Tables` technology it is possible to cover intelligent synchronization of data. Synchronization repots subsystem creates detailed report about synchronization session in HTML format.
Query, edit, browse, and manage databases. RazorSQL includes an SQL editor, database query tool, and built in database. Visually create, edit, alter, drop, and view objects as well as import and export data. Browse objects with the database browser.
Apex SQL Tools has released new version of Apex SQL Report. Apex SQL Report is a web solution crafted for SQL developers. Apex SQL Report is a SQL tool that generates HTML and graphical reports.
ApexSQL Log API is a programmable API that adds transaction log auditing capabilities to your own applications. It enables you to tap into ApexSQL Log’s auditing capabilities and functionalities eliminating the need to code them yourself.
ApexSQL Diff API is a programmable API that allows you to use ApexSQL Diff`s comparison and synchronization engine in your own applications eliminating the need to code them yourself.
ApexSQL Recover is a powerful recovery tool that recovers lost/corrupted data that normally cannot be recovered anymore. ApexSQL Recover even allows for selective recovery from backup.