This is going to be a pretty popular addition to IIS 7.X for application developers. The idea is that the database manager scans for database connections in your web.config file and allows you to perform basic administrative tasks via a web console instead of logging in via SQL Management Studio. No ports need to be opened for administration. That’s a tidy solution for remotely hosted websites. However, I’d still recommend revealing as little as possible to the net; you’re better off logging into the hosted server via RDP and using the management studio console. But if you want, you can use this solution. It’ll definitely be a player for internal deployments.
- 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
It’s a Release Candidate (not for production yet). MS are promising some documentation soon.