Switch to: V10V9V8V7V6V5

SQLDiff Wizard

This wizard serves for tuning comparing parameters and running comparison process in few steps:

  • Select Datasources (databases for comparison)
  • Setup comparison parameters
  • Assign tables mapping to show SQLDiff what objects was renamed
  • Execute comparison
  • Show the comparison statistic.

Since version 6.6 Valentina Studio Pro introduces SQLDiff Project file that contains all above settings. So you can create project once and reuse it to avoid tuning the comparison params every time.

In the end of work, if you use Pro version of Valentina Studio, the wizard will send you to the page with result, where you can synchronize databases or do other things.

1 - Select Datasources

At this step should determine Source and Destination databases for comparing. It can be any database supported by Valentina Studio (Valentina (local or server), SQLite (local or powered by Valentina Server), PostgreSQL, MySQL, SQL Server). You can select a particular database from the objects trees or load SQLDiff project that already contains info about datasources that will be loaded automatically.

1(a) - Select Databases

SQLDiff does not allow to compare databases from different DBMS. Or the same database.

SQLDiff Wizard Help -- Datasources

  • Search fields – will help to filter databases by name.
  • Synchronise filters – helps to search immediately in both trees.
  • Connect to… – Invokes drop down menu where you can choose the connection among bookmarks, or invoke Connect Dialog to establish new connection to the database server.

1(b) - Select SQLDiff Project

SQLDiff Wizard Help -- Poject

  • Load From SQLDiff Project – determines whether comparison settings will be loaded from the SQLDiff project file.
  • Run deployment immediately after comparison – if ON deployment will be started right after comparison according to the projects settings.
  • Load for next session – if ON the selected project will be loaded automatically on opening the SQLDiff Wizard

If the project was selected the Run button will become available immediately. You can start comparison in any time or change comparison settings and save them lately to the current project on the result page.

1.2 - Map Schemas

Optional for PostgreSQL and SQL Server

on this page you can set pairs of schemas that should be compared.

SQLDiff Wizard Help -- Schemas mapping

  • To Exclude Schema – switch off the appropriate checkbox

2 - Set Parameters

At this pages you can select types and properties of objects, that should be compared.

SQLDiff Wizard Help -- Parameters of Comparing Page

  • Objects – Displays kinds of database objects, that should be compared. If the object's kind is checked, it means, that objects of this type will takes a part in the comparing process. Otherwise, objects of the unchecked type will be skipped on comparing.
  • Object Properties – Displays the list of properties for selected object in the Objects panel. If the property is checked, it means, that values of this properties will takes a part in the comparing process. Otherwise, this property of the selected object kind will be skipped on comparing.
  • Options – Allows to set the additional comparing options.

Options of Comparing

The options for comparing differ for supported databases:

ValentinaSQLDiff compare options - Valentina
PostgreSQLSQLDiff compare options - Postgre
SQLite and MySQLSQLDiff compare options - SQLite and MySQL
  • Compare Properties – If ON the properties of objects will not take a part in comparing. If OFF the properties of objects will be skipped on comparing.
  • Key for Comparing – [Valentina and PostgreSQL] Sets the key, that defines the object. Can be the NAME of the object, or the ID of the object.

3 - Tables Mapping

This page serves to prevent lost data on synchronizing renamed tables or fields. Here you can point SQL Diff what objects are equal despite to different names.

SQLDiff Wizard Help -- Tables Mapping

  • Use Mapping – Enables objects mapping. If this flag is OFF then SQLDiff will not use user mapping.
  • Schemas Mapping – Shows the pair of schemas to witch current tables belongs (look step 1(b)).
  • Filters – Allows to show certain objects according to matching flags:
    • Full – Shows that objects are equal
    • Partial – Applied to tables and shows that not all fields was mapped
    • None – Shows that particular source object do not have corresponded object in the destination database
  • Search Fields – Allows to search Tables by name
  • Clear Mapping – Unmaps all objects.

If flag Use Mapping is ON and mapping is empty SQLDiff will generate script to recreate all objects. This will lead to lost data.

  • Map All – Automatically maps all objects by name.

4 - Statistic of Comparing

At this page you can see a statistic of comparison, such as the number of compared objects, the number of different objects and the time of comparison.

  • Close on finish – if ON the wizard will be automatically closed when comparison will be finished.

The View Result button will forward you to the page with result of comparing - difference between databases.