Visual Studio .NET 2003 shipped a web based sample application for management of SQL Server, based on ASP.NET and SQL-DMO. We're currently working on an updated version of that tool. This is a quick list of the things that we change:
- Revamped UI
- Improved navigation
- Improved architecture to make adding new components easier
- Fully based on ASP.NET 2.0 and SMO
- Works now with SQL Server 2000 and SQL Server 2005
We focussed on extensibility, so adding new features is a breeze. In fact, I created Assembly management from scratch within 2 hours on the plane to TechED, which I will demo coming Wednesday.
This tool is going to be made available as a Shared Source project. This means you can contribute to this project if you sign up to be a team member; or download the code and modify it for your own purposes (and push your changes back to the development team). We're not ready yet to allow you to sign up for team member, as we're still working on the '1.0 release', but if you're curious how it looks like, take a look at http://microsoftsqltools.com/. You can already sign up as member, and place feature requests as well. If you feel strong about certain features, I advice you to place feedback already. The earlier you are, the more chance it will make it as a feature!
If you're at TechED Europe, you can see a demo of this new tool:
"DAT310 Programming SQL Server Management Objects (SMO)" (Wed Jul 6 12:00 - 13:15)