SQL Server Performance

scriptdb - free script generating tool

Discussion in 'Contribute Your SQL Server Scripts' started by jezemine, Oct 22, 2006.

  1. jezemine New Member

    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:

    http://www.elsasoft.org/tools.htm

    hope it's useful to some of you!

    _____________________________________

    SqlSpec - a fast, cheap, and comprehensive data dictionary generator for SQL Server 2000 and 2005 - www.elsasoft.org
  2. Luis Martin Moderator

    I've moved to relevant forum.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



Share This Page