THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Andy Leonard

Andy Leonard is an author and engineer who enjoys building and automating data integration solutions. Andy is co-host of the Data Driven podcast. Andy is no longer updating this blog. His current blog is

The Database Design Process

This blog has moved! You can find this content at the following new location:

Published Thursday, January 21, 2010 8:00 AM by andyleonard

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Buck Woody said:

Very well done - thanks for sharing!

January 21, 2010 10:32 AM

Alex K said:

Hi Andy,

Can you please elaborate on: "Will your scripts build the database from scratch? Will the same scripts only apply changes to bring the database up to the latest version?" Why the need for one and the same script? I have only the script which builds the database from scratch. For my deployments, SQL Compare generates the scripts for me without much effort. What in my approach is incompatible with Scrum?

Also I agree on "Script the tables in T-SQL" - IMO it's more efficient this way.

You have not mentioned any unit tests yet. Are you planning to describe that later?

January 21, 2010 11:40 AM

Andy Leonard : The Database Design Process said:

January 21, 2010 3:11 PM

Peter said:

I actually added some DDL Audits to keep up with what the team changes as far as Schema.  Data changes are a separate issue and harder to capture unless we start adding triggers to e-mail me every time key data changes in a known lookup-type table.  I blogged about my DDL audit method and that may be useful to some others.

February 16, 2010 6:54 PM

Leave a Comment


This Blog



My Latest Book:

Community Awards

Friend of Red Gate

Contact Me


Privacy Statement