I have reverse engineered my database using the db admin tool.  How do I re-import the database?  Currently I take the file produced by the
reverse engineering process and "chop" it up since it appears that I can not just copy and paste it into a single SQL statement.  Is there a way
to use the output file from the reverse engineer function to re-create the database?  Basically each site will have the same database so I am
trying to automate the process.  Any advice would be appreciated.

Thanks
Scott

Scott


Wait for 1.06 which should have script capability or alternatively write a small utility to extract ; delimited statements and execute one at a time.

Roy Lambert

Thanks for the reply.  Is this the method that should be used from an installer
when setting up a new machine (will the script be able to run stand alone)?

Scott

>Thanks for the reply. Is this the method that should be used from an installer
>when setting up a new machine (will the script be able to run stand alone)?
>

No idea. It depends I would guess on your installer.

Roy Lambert

Scott,

<< I have reverse engineered my database using the db admin tool.  How do I
re-import the database?  Currently I take the file produced by the reverse
engineering process and "chop" it up since it appears that I can not just
copy and paste it into a single SQL statement.  Is there a way to use the
output file from the reverse engineer function to re-create the database?
Basically each site will have the same database so I am trying to automate
the process.  Any advice would be appreciated. >>

Currently, the only way to do an automated creation is via a stored
procedure that the reverse-engineering can create.  However, shortly that
will change when 1.06 is released since it will allow you to use just a
script to do the database creation.

--
Tim Young
Elevate Software
www.elevatesoft.com