Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread reverse engineer => install script
Tue, Aug 5 2008 6:05 PMPermanent Link

"David Cornelius"
I would like to setup a database with all the tables, constraints, stored
procedures, etc., adding and changing things as I design and develop an
application, then when I am finished, simply reverse engineer the whole
database to one script that I could deploy with my application that would
use it to create the new database on the customer's computer--without having
to rearrange the tables or pull out constraints that get caught because the
generated script is trying to establish a foreign key before the referenced
table is created.  (Whew!  that was one sentence!)

Now the reverse engineer feature is nice and I use it often, but with table
constraints, I can't just immediately send it back to EDB to recreate the
database--UNLESS I put them all in the right order to begin with, with
referenced tables created before the tables with foreign keys.

I would like to see the Reverse Engineer feature separate out the
constraints to ALTER TABLE statements and place them after all the tables
are created (this is what SQL Server does).  Then it wouldn't matter in what
order the tables are created and a reverse engineer would always work to
recreate the database from scratch!


After this is implemented, I would like to see all my tables (and stored
procedures, etc.) in alphabetical order...  Smile

--
David Cornelius
CorneliusConcepts.com
Wed, Aug 6 2008 8:00 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

David,

<< I would like to see the Reverse Engineer feature separate out the
constraints to ALTER TABLE statements and place them after all the tables
are created (this is what SQL Server does).  Then it wouldn't matter in what
order the tables are created and a reverse engineer would always work to
recreate the database from scratch!

After this is implemented, I would like to see all my tables (and stored
procedures, etc.) in alphabetical order...  Smile>>

I'll make a note of this.  The reverse-engineering is getting an overhaul
pretty soon, so I'll make sure that this is all included.

--
Tim Young
Elevate Software
www.elevatesoft.com

Wed, Aug 6 2008 1:48 PMPermanent Link

"David Cornelius"
> I'll make a note of this.  The reverse-engineering is getting an overhaul
> pretty soon, so I'll make sure that this is all included.


Thank you!

--
David Cornelius
CorneliusConcepts.com
Image