跨平台比较和同步SQL Server、Oracle和MySQL的架构和数据。
跨平台比较
SQL DXP可以对同类数据库进行比较，因此SQL Server与SQL Server之间的比较方式与SQL Delta执行比较的方式相同。此外，SQL DXP可以比较不同的数据库服务器，并从SQL Server、Oracle或MySQL跨不同平台传输模式和/或数据。
模式比较
SQL DXP将源数据库的各种对象转换为目标数据库的兼容对象。例如，MySQL到SQL Server将MySQL数据库转换为SQL Server形式，这样比较就可以进行。
请务必注意，并非所有对象和特性都可以转换。MySQL不支持SQL Server的功能集，但是对象保持原样，以显示源数据库的整个模式。
数据比较
考虑到常见的数据类型，跨平台数据比较可以更加紧密地结合在一起。数据比较提供了一种从两个不同平台传输数据的便捷方法，通常用于将基于web的MySQL数据传输回后端SQL Server数据库。
新鲜事
修复了varchar-nvarchar列的表大小检测问题
对Oracle脚本生成的重大改进
大容量表更改的性能改进
修复了打印模式比较加载错误文件的问题
漏洞修复
SQL DXP Premium 6.6.1.183
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.
Schema Compare
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.
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
Fixed table recreate size detection for varchar – nvarchar columns
Significant improvement to Oracle script generation
Performance improvement for large volume table changes
Fixed print schema compare loading incorrect file
Bug fixes
OR
