SQL round-trip designer

Posts   
 
    
C4 avatar
C4
User
Posts: 32
Joined: 12-Nov-2005
# Posted on: 17-Feb-2006 23:39:45   

Does anyone know of a good SQL Designer that will do both reverse engineering and forward engineering that is both stable and mature???

What are you guys using to design the actual database structure and manage it through the application life-cycle...

bclubb
User
Posts: 934
Joined: 12-Feb-2004
# Posted on: 18-Feb-2006 02:50:39   

Well not exactly sure what you are looking for, but I use Red-Gate sqlcompare to syncronize our prod and development databases. Take a look at the demo and see if this is what you are looking for. It does not provide anything for designing, we just use the SQL Management Studio and Enterprise Manager for that.

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39588
Joined: 17-Aug-2003
# Posted on: 18-Feb-2006 09:35:00   

Visio with its ORM designer (object role modelling that is wink ).

Frans Bouma | Lead developer LLBLGen Pro
erichar11
User
Posts: 268
Joined: 08-Dec-2003
# Posted on: 21-Feb-2006 15:35:27   

I've been using Visio, but it is so..... slow. Saving a model takes 10 minutes with 30 tables (and some times it just fails). Looking for alternatives as well to create a db module. Any sugesstions.

Devildog74
User
Posts: 719
Joined: 04-Feb-2004
# Posted on: 22-Feb-2006 06:17:00   

I use erwin for modeling and sql packager to script new databases and db upgrades. Once we begin development, all objects are scripted and put into our CI process. Every time we do a build, the db and all objects are re-created. The same process is followed for nightly, and QA builds.

for production releases we create a package using sql packager comparing the most recently approved qa database and the current production database.

in my current environment, development teams do not deploy to production servers, only infrastructure can do that.

new development, design, and modeling is done with erwin. when the model has been approved, we script the objects related to the new subject area(s) in question and integrate the new subject areas into the CI process.

pilotboba
User
Posts: 434
Joined: 05-Aug-2005
# Posted on: 22-Feb-2006 20:38:08   

Devildog74 wrote:

for production releases we create a package using sql packager comparing the most recently approved qa database and the current production database.

How do you handle changes that can not be done with a simple compare tool?

BOb

Devildog74
User
Posts: 719
Joined: 04-Feb-2004
# Posted on: 23-Feb-2006 04:25:15   

Fortunately we havent run into this scenario yet. Sql Packager literally looks at all objects in the schema.

I suppose that if we ever run into it, we will need to get a production DBA to run pre-upgrade scripts on the production database, then run the upgrades.