SQL DXP Premium 22.214.171.124
File size: 68 MB
Cross Platform Compare and Sync Schema and Data for SQL Server, Oracle and MySQL.
Cross Platform Compare
SQL DXP can compare like for like databases, so SQL Server to SQL 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 from SQL Server, Oracle or MySQL.
SQL DXP will convert various objects of the source database into compatible objects for the target database. For example MySQL to SQL Server converts the MySQL database into a SQL 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 SQL Server however the objects are left as is to show the entire schema of the source database.
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.
Support for Active Directory Authentication
For the new Active Directory Authentication requires the latest OLEDB driver which can be found at the link below (Valid Jan 2021).
Fixed issues supporting SQL Server 2000
(Buy premium account for maximum speed and resuming ability)