Just a quick note to let you all know about a (free) app I wrote that will script all the objects and (optionally) data in any 2000 or 2005 database. I know this is already available in EM and SSMS, but this is a cmd line tool. much easier to automate, etc.

It creates a separate file for each object, in a directory tree structure similar to that in Object Explorer in SSMS. It's very useful for getting your database scripts under source control if they are not already.

I posted the source as well so you can easily modify it to meet your needs if you know a little C#.

You can get it here:


hope it's useful to some of you!