Re: Using sql files instead of the DB itself

Hi Erik,

Do you do anything in your build process to set up the equals() method, or
sequence names?  Am having difficulty automating this...

cheers,

David



|---------+------------------------------------------>
|         |           Erik Wright                    |
|         |           <[email protected]>      |
|         |           Sent by:                       |
|         |           [email protected]|
|         |           ceforge.net                    |
|         |                                          |
|         |                                          |
|         |           08/10/2004 09:28 AM            |
|         |           Please respond to              |
|         |           middlegen-user                 |
|         |                                          |
|---------+------------------------------------------>
  >------------------------------------------------------------------------------------------------------------------------|
  |                                                                                                                        |
  |       To:       [email protected]                                                                   |
  |       cc:                                                                                                              |
  |       Subject:  Re: [Middlegen-user] Using sql files instead of the DB itself                                          |
  >------------------------------------------------------------------------------------------------------------------------|




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






-------------------------------------------------------
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