Three Rules for Database Work

K. Scott Allen over at odeToCode.com has these three rules for developing with a database:

1.  Never use a shared database server for development.

I’ve been preaching this one for years and hardly anyone will listen to me.  Everyone has their own local copy so that no one stomps on anyone elses work.  Duh!  But, you think I can convince anyone?

2.  Always have a Single, Authoritative Source for your schema.

Well, I guess if you all work off the same database, this isn’t an issue.  But, if you all have a local copy.  You’d better have one place you know has the real deal.

3.   Version your database.

Absolutely.  Other than scripting every change that is made, you have a reasonable way to do this?  Scott says he does.  Can’t wait to see it.

Related Post

Comments are closed.