What should be the automated build steps for a database?

Every-time I check in, I want to trigger Nant build script to run some开发者_开发技巧 tasks for the database in the project in Dev/Uat/Live server to clean db, reload contents of db etc.

What should be the steps as I have never done it before? Is there an article that talks about automated database built steps which you can recommend?

Thanks.

---

I just found this one and it is not bad: bottleit.com.au/Blog/post/Continuous-database-integration.aspx. He created an osql target and sets a script file. The osql target will run the script file based on properties in the nant script (database, user name, password). You will, of course, need osql on the build machine for this to work. Everything in sql server 2008 is scriptable, from creating to restoring databases. So my suggestion is to do what ever you need to do manually, save it as a script file and use that script file in your build script.