Re: ER/Win vs Designer/2000 - Which is better?

From: David Welchman <David.Welchman_at_funb.com>
Date: 1997/04/03
Message-ID: <01bc407b$c168d7c0$3a0bafa8@dwelchman>#1/1

Roger Snowden <rsnowden_at_IHateSpam.com> wrote in article <01bc3f7a$0464b4c0$096fc589_at_RSNOWDEN.labinterlink.com>...

>With ERWin, if you want to add a column to a table, the tool

> generates a script to recreate the table. D2k will generate the 'alter'
> statements. May not sound like much, but if you need to get control of an
> existing environment, or need to understand the differences between a
> development and test instance, you have to have D2k. D2k has come a long
> way.

Actually, ERwin 2.6 does the incremental changes to a database now. They call it 'bi-directional sync', and it works pretty well. You can compare your model to a physical database (or to another model) and only the differences will be highlighted. You can then either make your model look like the database, or make your database match the model, or any combination of the above. If you want to alter a table, it will generate code to create a temporary table to hold the old data, then create a new table with the new structure, then copy the old data back into the new table. This is great for on-going maintenance of a database, which ERwin used to be lousy at. Version 2.6 is definitely worth the cost of the upgrade. Received on Thu Apr 03 1997 - 00:00:00 CST