SQL DXP for SQL Server and MySQL v6.5.0.164

SQL DXP for SQL Server and MySQL v6.5.0.164
SQL DXP for SQL Server and MySQL v6.5.0.164

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.

Project Manager
Tabbed Projects
Run two or more projects side by side in separate tabs, whether it's two schema compare projects on completely separate servers or a schema compare and data compare project on the same server.

Because each process is run in separate threads you can be reviewing or even running an update script while waiting for other compare processes to complete.

Show Compare
Group Projects
You can assign each project to a project groups making organizing your projects easier. You can place all your data compare projects into a data group. Place a specific server group of projects under one group.

Schema Compare
Straight Forward Compare
Comparing two databases is quick and easy. In a new project select your source database target then your target database and click to run your schema compare.

SQL Delta shows an overview of all the objects that are different or not in either the source or target. By selecting each object you can see at the schema level the various differences.

Show Compare
Comprehensive Project Options
Each schema compare project has a range of options to reduce discovery common differences. For example objects constraints with system names are usually different between source and target and these can be ignored.

Schema Mapping
For some projects your target schema names (owners) are different to your source schema names. Each compare project has the option to map source schema names to target schema names.

SQL Delta can then optionally automatically change the definitions to use the correct schema name. For example your source database uses "dbo" and your target uses "prod" as the schema name for all objects. Simply map dbo to prod and any script changes will ensure the target object is prod.object instead of dbo.object.

Comprehensive Search and Filtering
Within the compare results the objects can be filtered based on a range of options. For example hide all objects that are the same is a frequent filter.

Filters can be persisted so whenever you re-run the project the filter is re-applied. This persistence can also be used to preselect or pre-deselect objects which is handy if you have objects in your source that should not be sent to target.

Filter Schema Load
You can apply a filter to the schema load to exclude objects from loading. For example you could have a set of functions that are part of your source database that are never part of your target database. By adding the load filter you can exclude these functions from the load and therefore the compare.

Two Click Synchronize
Once the schema compare tab is shown simply click Script to generate the deployment script and then click Execute to apply to the target.

Report on Compare
SQL Delta can generate an HTML report of the schema compare highlighting the object differences throughout the schema.

Show Compare
Modify Script Before Deployment
Sometimes it's nice to be able to change the script or add script to the final deployment script. The synchronize script is completely editable plus within project options you can add custom script that is added to the sync script for each deployment.

Data Compare
How does it work
Data compare uses one or more indexes columns, usually the primary key, to determine if a row in source matches a row in the target table. If a match is found then data compare scan each column looking for differences.

Show Compare
Comprehensive Configuration
By default Data Compare is straight forward, select the source and target databases and run the compare. SQL Delta automatically determines the tables with primary keys and matching column names and performs the compare.

If you wish to get more granular you can select the tables to compare, define your own index columns and even define the columns to compare.

Table and Column Mapping
Sometimes a table in the source database has a different name to a table in the target database. Data compare can map the source table name to the target table name. The same applies to columns where a source column can be mapped to a target column. Data compare takes care of the name changes within the deployment scripts.

Data Filtering
Table data can be filtered to exclude specific rows during load and the filters use standard where clause formats.

Column Conversions
Columns can be configured to apply a conversion for comparison or for both comparison and scripting.

For example you might like to compare a numeric column that stores to 2 decimal places (money values) however in this instance only whole numbers are significant to you.

You can apply a round(..) conversion to the column and this will remove the decimal values and compare the whole numbers.

Data Filtering
Table data can be filtered to exclude specific rows during load and the filters use standard where clause formats.

Data Compare Views
Views can be optionally included as part of the data compare.

A source view could be used to map to a target table providing a method of populating a target table from a view.

Export Data Compare Scripts
The data compare script can be huge and is automatically saved to file during the scripting process.

Data compare script display can show millions of lines of code so you can view even the largest deployment scripts.

Report on Differences
Generate an HTML report showing the difference summary for your data compare.

Schema View
View your database
Schema View is an editor function that shows the entire schema of your database.

For objects such as tables and views you can also see the data within the table or view.

Schema View
Looking for something within your database? Schema view can filter down to the definition level of objects so you can quickly locate elements within your database.

Dynamic Queries
Run DML or DDL queries against your database.

For example perhaps the schema compare shows an unexpected change to a source table and you want to review the data and other information relating to both source and target database.

From the project manager duplicate your compare project, switch it to a schema view project and run it. You can now see the original schema and data within tables and views. Perhaps the data explains the change or comments in the table provide more information.

Users of Guests are not allowed to comment this publication.