SQL DXP for SQL Server and MySQL 6.5.8.173

[mitsumi]

File size: 68 MB
Cross Platform Compare and Sync Schema and Data for SQL Server 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.

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:
Add new script option ForceCurrentForDatabase option to force any ALTER DATABASE to use current instead of specific target database name
Added Snapshot load filters. A snapshot can have objects filtered in the same way as normal schema load.
Added new load filter. This applies the filtering text to only the object type such Table, View, etc. The dropdown list shows the object type key words and then surround with <>. For example%Apollo% will exclude all tables with the name containing Apollo. All other objects are loaded without filtering.
Fixed incorrect database script for change tracking
Fixed table change tracking scripts
Fixed crash during script generation
Fixed including timestamps in recreate table process when timestamp columns are insert mapped
Improved column mapping/matching in schema table recreate including improved automatic data copy selection
Improved column mapping messages in schema table recreate
Bug fixes

Download link:

Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction