Database Manager for IIS 7 RC Preview

I recently had a chance to preview the Release Candidate of Database Manager 1.0 for IIS7. If you are looking for a very lightweight tool that is easy to install for doing basic operations against SQL Server used by your IIS applications, this tool is just for you. It’s much smaller than SQL Server 2008 Management Studio Express (SSMSE) – of course that means less features.

In what Database Manager lacks in features, it makes up with a simple query editor that will run your statements in the window as a batch. The query editor has simple colorization to point out keywords to catch obvious mistakes.

What makes Database Manager nice for developers is that it connects directly to your application’s database. This way you can focus on your project instead of seeing everything possible with the server like you get with SSMSE. You can connect to additional databases within their explorer.

As you can see, the explorer only shows Tables, Stored Procedures, and Views. If you want to create other objects, you’ll need to use the query editor.

Features include:

Add, rename, drop, and edit tables

View and manage primary keys, indexes and foreign keys

Data editing

Establish connections to multiple databases

Create and execute queries

Create, alter and delete stored procedures

Create, alter and delete views

Manage stored procedures

Manage both local and remote database from your machine

IIS 7.0 Manager provides remote management capabilities with a clean firewall-friendly option for managing a remote SQL Server

Exposes a public extensibility platform that enables the development of providers to support other databases

Compatible with SQL 2008 and 2005

If you are using IIS 7.0, I recommend the Database Manager for those times you want to test out your queries for your application or make tweaks to existing objects.

The IIS team has put together a nice set of tutorials and videos on their download site at http://www.iis.net/extensions/DatabaseManager

Technorati Tags: Database Manager IIS,SQL Server 2008 Express