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.
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