Search the whole database
The DbSearch tool allows to search at once the whole database or selected table by multiple values, like on below
screenshot we search for rows with values "Test", "Search" or "Value":
Above search values will display following search results window:
By setting the "AND" seperator, it's possible to search for values that contain more than one value.
For example if we set "#" as the "AND" seperator:
and then set the values fields in following way:
Displayed will be the rows which contains the value "Test" and "cm" and the rows which contain both values "Search" and "img"
Explore the database
The table explorer allows to look through the data stored in the tables, it contains several utilities to make it easier to filter the data or
build complex where clauses.
After a table is selected, the first 100 rows are displayed
We can use the fields in the columns to filter the data
Use the filter wizard to construct complex where clauses, for example following wizard setup:
Will generate following query:
It's also possible to freely edit the sql query, and to make changes in the row data and commit the changes.
Compare database structure
With the structure comparer we can select two database and generate an overview of the
differences in the structure of the two selected databases.
The overview contains information about the structure differences, as well as functions to migrate the
differences from one database to other.
It allows to view differences in the existing tables
Differences in existing columns
And differences between types of columns that exist in both databases
Compare database data
The data comparer analyzes all tables in two databases and makes an overview in the differences between the
data contained in the rows of the tables.
It allows to generate a merge query which will insert, update or delete the rows with data from one database
into another.
We can either select the merge direction for all selected tables, for single tables, or whole rows.
It's also possible to select, if DELETE statements should be included in the query for rows that
exist only in one database.
Each table with differences in the contained data can be analyzed row by row, and rows can be selected from
which the differences should be included in the merge query
After we select the rows and/or tables for which the merge query should be generated, we can
have a look and analyze the generated query.
