Project DescriptionScriptDb 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.
You can also (optionally) specify to script the extended properties for each object along with the DDL.
ScriptDB was originally written by Jesse Hersch of
http://www.elsasoft.org. It's hosted at codeplex now for the benefit of the community.