HomeActive Query BuilderMultiple Databases Support

Multiple Databases Support


Hi all,
maybe somebody could explain to me what the "multiple Database" feature is able to do.

- do all the databases have to be of the same type
- is there an example of (a) generated SQL statement (statements)
- which databases support this feature?

Thanks in advance for your help.
Peter | email
May 27 2009, 11:36 AM
Dear Peter,

Active Query Builder is intended to build, parse and analyze SQL queries, but not to execute them in any way. This means that you may load metadata from several databases at once into the component's metadata container, and the component will be able to build a query using these objects (by the rules of specific syntax provider).

Thus, if you add objects from several databases of a single MS SQL Server, this server will be able to execute this query. But if you'll try to add object from several servers not linked with each other, no one can execute this query.

Some database servers (ex. MS SQL, Oracle) allow to link tables and entire databases from other servers and execute SQL queries against them.

The other way is to analyze the query, execute it's parts against respective database servers and combine their results. It is not easy to implement, but I know that some of our customers have dealt successfully with this task.
Sergey Smagin | email
14 hours, 25 mins since original post
This topic is closed