BuildDB – Open Source Tool for the Agile SQL2005 Database

I’d like to announce the beginning of a new open source project to fill a hole in the set of tools needed for an Agile Database / Datamart built on SQL 2005.

The name of the project is BuildDB and it is hosted by Google Project Hosting under the GNU General Public License 2.0.

In consultation with a friend and colleague, Greg Graham, I wrote a tool that will build a SQL 2005 database from script files using a command line console app.  The app is written in Visual Studio 2005 on the .NET Framework 2.0.  The project is definitely not finished and I hope that maybe a person or two will step up and help me test it and maybe even do some coding.

It works like this:

BuildDB [TargetServerName] [TargetDBName] [ScriptsRoot]

Under the ScriptsRoot directory, the application looks for these directories: “Logins”, “Users and Roles”, “Tables”, “User Defined Functions”, “Views”, “Stored Procedures”, “Triggers” and “Static Data”.

The tool will go through these directories and create the database and then run the scripts in the “Static Data” directory allowing the opportunity of inserting data right from the get-go.

There are already some known issues with the application and also some enhancements that I’ll be working on in the near future.  Even with these issues and enhancements outstanding the tool is pretty useful but maybe incapable of building a super complicated database.  If someone tries the tool and finds any other issues that I don’t have identified in the Issues List, please add it or get in touch with me via this blog.

Advertisements

One Response to BuildDB – Open Source Tool for the Agile SQL2005 Database

  1. Mark, I work with the company that builds and manages the Microsoft techedbloggers and pdcbloggers sites. We have a site into its 2nd year for the IT Pro Webcast and Events team http://www.techneteventsbloggers.net. May I register your blog on this site? The community would benefit from the posts you write on SQL and on topics BI related. It would be great if we could aggregate your posts to this noise free site. In return, this is a very active RSS Feed and we can help drive traffic to your site.

    Thank you and we look forward to your posts.
    Kathy Schuler
    http://www.indepth-tech.net
    InDepth Technology,
    Kirkland, WA

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: