Database Compare Suite allows for creating virtual views. These objects store the result of query execution and can be created for all supported relational databases. NoSQL databases do not support them. Virtual views can be included in data operations alongside regular objects.
Database Compare Suite treats a virtual view as a special virtual metadata type. These objects are available only within the scope of the project. All these views are in the virtual views category of the database metadata tree in Database Compare Suite.
This page provides an overview of virtual views and describes the typical workflow of using this type of objects in Database Compare Suite.
To add a new virtual view, right-click on the virtual views category in the database metadata tree. Then select the Create virtual object option from the virtual view menu item.
Then, the Virtual view query editor window opens. Specify the query to define a new virtual view.
Use the following rules to configure a virtual view:
Specify the virtual view name instead of QueryN used by default.
Use the Load script button to upload an existing script from the file.
Press the Load script button to make sure that the script is correct.
Press the Save and close button to create a new virtual view.
Now this virtual view can be used in data operations as a data source. Users can specify all data operation options for a virtual view in the same way as for real objects.
Press the Edit virtual object button to edit an existing virtual view.
Press the Remove virtual object button to remove an existing virtual view from the project.
Database Compare Suite has several limitations for the matching operation. These include:
Matching rules cannot be applied for virtual views.
Columns of a virtual view are always matched to target object columns by ordinals. If the column order in a virtual views does not meet the requirements, you need to edit the relevant query using the Edit virtual object option of the pop-up menu.