RE: how do you handle your DDL builds?

From: Brady, Mark <Mark.Brady_at_Constellation.Com>
Date: Wed, 14 May 2008 10:31:33 -0400
Message-ID: <72AB68B424526641A8514835270C2EB502D0CE2D@EXM-OMF-21.Ceg.Corp.Net>

It's helpful to distinguish between the IT world and the ISV world. Is your product sold to other companies (ISV) or is it used for your business only (IT)?  

[] On Behalf Of Rick Ricky Sent: Wednesday, May 14, 2008 10:08 AM
Subject: how do you handle your DDL builds?  

We have a production database. We want to change tables, structure, etc... We do this frequently. How do you script this? So far I have been using upgrade directories.  




However, this leaves me with a problem. I can do an add column to a table in version1, but then I have to change my base DDL of the table, but how do I know that table works? Where would I test that my new create table statement works? You can do all this manually, but its slow, time consuming, and prone to bugs.

>>> This e-mail and any attachments are confidential, may contain legal, professional or other privileged information, and are intended solely for the addressee. If you are not the intended recipient, do not use the information in this e-mail in any way, delete this e-mail and notify the sender. CEG-IP1

Received on Wed May 14 2008 - 09:31:33 CDT

Original text of this message