Table of Contents
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.
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
- 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
- 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
1.2 - Map Schemas
Optional for PostgreSQL and SQL Server
on this page you can set pairs of schemas that should be compared.
- 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.
- 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:
- 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.
- 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.
- 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.