Indeed, Peter is correct.
We manufacture two products in our catalogue that will enable DBAs to
tackle the concept of Change Management. One is ER/Studio, a data
modeling application and the other, DBArtisan Change Manager. Both
these products utilize the same 'engine' to manufacture the intelligent
ALTER scripts (DBMS and DBMS version-specific) and ultimately handle
the concept of making one database 'look' like another. ER/Studio
utilizes a more traditional approach of utilizing data models as the
foundation of comparison. We offer DBArtisan Change Manager as a very
robust companion to our successful DBArtisan environment as a highly
GUI-driven method of comparing databases without having to have any
You've got your choice basically! I hope we can help you in some way to
help make this process simple and manageable for you. Visit
http://www.embarcadero.com to download any of these products to try.
Embarcadero Technologies, Inc
> You may want to consider a 3rd party tool. I know that
> Schema Manager from Embarcadero can do something like this
> (www.embarcadero.com). As far as ERD software goes, they're
> inexpensive and the programs are pretty good. The latest version of
> ER/Studio, 4.0, allows scripting of triggers and procedures as well.
> update the database, it will allow you to choose which objects to
> believe that altering the database generates a script by default. It
> be exactly what you're looking for, but it might be worth checking
> Other ERD software should be able to do this as well. I'm
> that ERWin can handle this well. Others on this group should have
> advice, I'm sure.
> -Pete Schott
> > Makes sense. I guess I was trying to avoid having to work out the
> > statements manually.
> > What I'm looking for is a tool that can, in effect, look at two
> > of a database and automatically generate the ALTER statements to
> > one into the other. Another way to look at it is having a tool that
> > could log each ALTER statement I execute on the database (even if I
> > execute them through the use of a visual tool, such as the database
> > diagram) and allow me to repeat those statements against another
> > of the database.
> > > You don't necessarily have to drop tables to modify them. Might
> > > the functionality now available with the ALTER syntax. As far as
> > > automating, I'll leave that to the gurus in the newsgroup.
> > > My $0.02
> > > --
> > > Patrick Logan, MCSD
> > > Senior Technical Development Advisor
> > > McKessonHBOC -- Extended Care Solutions Group
> > > Opinions expressed are my own and not necessarily those of
Sent via Deja.com http://www.deja.com/
Before you buy.