Create a new Query from various Data Sources

DBxtra allows creating Queries form more then one Data Source and also from different databases.

For example you can create a Query mixing data from databases like MS SQL Server and Oracle.

Create a Heterogeneous Query

Click the Heterogeneous Query button on the menu bar.

Select the first database connection.

Drag and drop Tables or Views to the Diagram Pane.

Select the second database connection.
It can be from the same Project you're working on or from a different project.

Drag and drop Tables or Views to the Diagram Pane.

Proceed as usual when creating a Query.

Important! When creating a Query from more then one database then you need to apply the MS Access SQL syntax.

Movies

Watch Movies