You could always load the SQL into a temporary schema/database, or a
Cloudscape/HSQLDB in-memory DB or something, and then point Middlegen at
that.
Our build process connects to Oracle, creates a user for the developer
performing the build (suffixes the user name with '_${env.USER}'), which
automatically creates a schema for them, then connects as that user and
inserts our schema via a SQL script. All that's left at that point is to
run Middlegen.
But if you don't have that kind of flexibility with your actual DB
platform, I suppose you could run a DB locally, either a Java one (which
might be easier to configure as part of an integrated build) or MySQL,
PostgreSQL, etc.
-Erik
On Tue, 2004-08-10 at 01:36, Jonathan Scott wrote:
> Hi All,
>
> I am wondering if it is at all possible to read tables from a SQL file instead of
> from the DB itself. The point being that the SQL files will tell us the current
> structure of the DB better than a possibly out of date schema, built only who knows
> when.
>
> If there is such a way to get the schema from files instead of the DB, please advise
> on how to do it, or where to look on how to do it.
>
> Much appreciated,
> Jonathan Scott
-------------------------------------------------------
SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media
100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33
Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift.
http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285
_______________________________________________
middlegen-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/middlegen-user
