Query in multiple databases

Thomas Flemming tf at ttqv.com
Mon May 25 05:00:12 CDT 2009


Hi,

I like to know, if there is some features in Valentina to easily access tables 
across multiple databases.

I have to deal with gigs of data, which is divided into 20-30 different 
databases. All databases have the same structure.

So when I do a query in a specific table, I would like the engine to look in 
all databases in this table.

Is this somehow possible?

I know, I can do a select with union, but maybe there is something more 
elegant with the api?

btw: all data-access is readonly in my case.

Best regards,
Tom


-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/


More information about the Valentina mailing list