Sneal - Validating SQL Scripts on Checkin

Saturday, February 09, 2008

« Initial Commit - SQL Migration Tool | Main | SqlMigration Entity Population Working »

I thought this looked like an interesting approach to validating your SQL statements in a continuous integration environment. Basically you execute the script with the NOEXEC option.

I'm not sure I would actually us it though since I think I would prefer to actually run the scripts and and then do some further processing, however maybe this is a good prebuild step?

AutoBuild | SQL Server

Saturday, February 09, 2008 5:39:37 PM (GMT Standard Time, UTC+00:00)

Disclaimer | Comments [3] | Related posts:
XML Data Migrations for SQL Server
Initial Commit - SQL Migration Tool
SQL Migration Tool Requirements
Join SQL Server Table to FTP Directory
SMO ScriptDrops = true Bug
Deploy to Test From CCTray

Thursday, January 08, 2009 10:47:18 AM (GMT Standard Time, UTC+00:00)

Hi I am unaware if there is any way, automatic builds can be done for SQL server 2005 code. It would be of a great help if you could let me know of the various possibilities of doing that.

I am looking at some applications / software that can be used to perform automatic build on the SQL server code the way Cruise control.net is used for .Net code.

Utkarsh

Thursday, January 08, 2009 8:24:52 PM (GMT Standard Time, UTC+00:00)

Just setup cruise control to run an NAnt or MSBuild script that builds your DB on the CI server's DB from the T-SQL scripts you have checked into source control. See K. Scott Allen's blog for a detailed discussion on how to do this, he has a series of posts on the subject (http://odetocode.com/Blogs/scott/archive/2008/02/03/11746.aspx).

For tasks
http://msbuildtasks.tigris.org/
http://nantcontrib.sourceforge.net/release/0.85-rc1/help/tasks/sql.html