Blog: Database Compare Suite 5.0 update brings a new user interface

The latest Database Compare Suite release significantly updates the design of our product. In Database Compare Suite 5.0, we updated the user experience and simplified the user interface.

The list of other updates includes:

Database Compare Suite 5.0

Caption

In addition to that, we updated the command-line interface of Database Compare Suite to simplify DevOps operations. Consider using Database Compare Suite in the CLI mode to automate your routine DevOps tasks related to application migration between different environments, database upgrades, and integrity checks.

Read the blog post to learn more about the latest application updates.

Matching rules

All data operations start with a data matching step. By default, Database Compare Suite creates object pairs by types, names, and parameters (for stored procedures and functions). However, you may want to change these default rules and specify these pairs manually. To do so, you need to create matching rules to build the desired pairs.

Database Compare Suite supports the following types of matching rules:

  • Manual matching rule
    You can match any pair of compatible metadata objects regardless of their location under the operation scope. Consider using this matching rule when you’re not satisfied with the default rules.
  • Category matching rule
    You can match the data objects, routine objects, and schema level objects in the source and target databases. You may want to use this matching rule, for example, to match the views and tables.
    Category matching rule
  • Object selection rule
    Consider using the object selection rule to include or exclude selected objects from the operation. You can apply this rule to the source or target database, or even to both databases. Also, you can use filters to select the object names.
  • Name conversion rule
    You can match the source and target objects with different names using the transformation of the source object name by a specific pattern. Source and target metadata types should relate to the family of the same objects.

Application settings

We simplified and redesigned the Database Compare Suite 5.0 application settings. Basically, we split the congested interface of the application settings window into several tabs. So, now the application settings interface is clear and simple.

Also, we used the same approach to modify the schema operations options. Now we display only the objects and properties that are relevant to the pair of databases under the current projects. Also, we added a new tab for type mapping here.

Data operations options

Finally, Database Compare Suite 5.0 includes an updated data operation options tab (shown on the screenshot above) and the sorting key selection wizard. You walk through these two steps when running the data operations like comparison, synchronization, and migration. Please note that Database Compare Suite requires a sorting key for each pair of tables or views in order to match rows between them.

License term changes

Also, in the latest version of Database Compare Suite, we extended the free trial period to 14 days. Also, the regular license now expires after 12 months from the activation date.

Please note that the whole new licensing policy is coming soon. In the next version, we will add the support of Microsoft Access databases, as well as introduce a new PRO license.

Free download

Discover the power of our Database Compare Suite by giving it a try during a 14-day free trial period. Avoid human factors and miserable errors in your data management, database administration, and application development operations. Download a free trial version of the Database Compare Suite application from the official page.

Also, be sure to read the series of blog posts that cover the core application features:

Share this...
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on LinkedIn
Linkedin