This project is read-only.


Multiple Databases


Hi to everyone, i'm trying Dynamic SQL Generator and it seems to work pretty well. Unfortunately i've a particular need that force me to launch query which access to multiple databases simultaneously.  Someone can tell me if Dynamic SQL can manage this kind of problem? If not, someone have some suggestions to point me in the right direction?   Thank you very much in advance to everyone!


perceiveit wrote Dec 12, 2012 at 8:07 AM

This should now be possible with the latest release.

There is DBQuery.Use("database name") statement for schema construction.

And a catalog option for the Tables, views and fields in statement construction.

DBQuery.SelectAllFields().From("catalog","owner","table") etc.

If not all statements are covered with the database - using an Alias for the table will always work.


wrote Feb 14, 2013 at 8:51 PM

wrote May 16, 2013 at 10:20 AM

wrote May 16, 2013 at 10:20 AM

wrote Jun 14, 2013 at 8:12 AM