Virtual Tables and Stored Queries Differentiation

Virtual Tables and Stored Queries are internal Cross-Database Studio Database Connection objects.

What is a Virtual Table?

Virtual Table is a "table" structure, combined from fields from different tables, using Order By and Where criteria.

What is Stored Query?

Stored Query is an SQL statement, created with back-end database SQL syntax, which may contain very complex relations between tables.

When do I use Virtual Table and when Stored Query?

Virtual table is recommended to be used for Comparison.

Stored Query is recommended to be used for Synchronization and Migration.

Why use Virtual Table for Comparison?

If you want to compare several fields from different tables in one database with several fields from different tables in another database, just create Virtual Tables in each database and compare them. You may also compare Virtual Table on one side with View or Table on the other side.

Why use Stored Query for Synchronization and Migration?

To Migrate and Synchronize structure (or data), defined in the database, you don't need to use Stored Query. But if you want to Migrate (or Synchronize) the result of a complicated query use Stored Query internal Cross-Database Studio object.