SqlSpec

Database Documentation: download SqlSpec Download evaluation version
Database Documentation: purchase SqlSpec Database Documentation: purchase SqlSpec
Required: .NET 4.0 runtime

You can purchase the full version for $149 via Amazon or Paypal.

Questions? Contact us, or ask on the forum.

Tools

This page is for free tools our development team has written that might be useful to others.


ScriptDb

ScriptDb is a simple console app written in C# that uses SQL Management Objects (SMO) to script all the objects in a database. It will work against any SQL Server 2000 or 2005 database. It creates a directory tree structure with a similar hierarchy to that in Object Explorer in SSMS, with a separate file for each object.

It will also (optionally) script the data using bcp.exe.

It's useful if you want to get the scripts for a database into source control that isn't already under source control.

Because it uses SMO, you'll have to install it if you don't have it already (if you have SQL Server 2005 client tools installed, you already have it). You can get SMO here (search for "SMO" on the page).

Also included in the download is a .bat file that loops over your generated scripts and executes them. Using the .bat file, you can deploy your scripts to any other server/database. See builddb.bat in the download for details.

ScriptDB was originally hosted on the elsasoft.com site, but it's been moved to www.codeplex.com for the benefit of the community, so others may more easily contribute to the codebase if they choose.