File size: 68 MB

Cross Platform Compare and Sync Schema and Data for Oracle and MySQL.

Cross Platform Compare

SQL DXP can compare like for like databases, so Oracle Server to Oracle Server the same way that SQL Delta performs a compare. In addition SQL DXP can compare different database servers and transfer the schema and/or data across different platforms.

Schema Compare

SQL DXP will convert various objects of the source database into compatible objects for the target database. For example MySQL to Oracle Server converts the MySQL database into a Oracle Server form so the compare is then like for like.

It is important to note that not all objects and properties can be converted. MySQL doesn't support the feature set of Oracle Server however the objects are left as is to show the entire schema of the source database.

Data Compare

The cross platform data compare can be more closely aligned given common data types. Data compare provides a convenient way to transfer data from two different platforms with a very common use transferring web based MySQL data back into a backend SQL Server database.

Whats New:

New internal database connectivity

Improved support for various data types

New keyboard actions in View project, (Ctrl+Shift+D - duplicate line, Ctrl+Shift+Up/Down - move row up/down)

Improved Dependency manager

Improved Script generation

Within preferences changing data folder could fail

Bug fixes