Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Enhancement Requests and Suggestions » View Thread |
Messages 1 to 3 of 3 total |
reverse engineer => install script |
Tue, Aug 5 2008 6:05 PM | Permanent 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... -- David Cornelius CorneliusConcepts.com |
Wed, Aug 6 2008 8:00 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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... >> 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 PM | Permanent 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 |
This web page was last updated on Friday, March 29, 2024 at 03:30 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |