Does anyone know of a similar tool as phpmyadmin for sqlserver ? Especially the data dump is very handy. But also updating etc, without needing to remotely logon etc. is nice.
4 Answers
Yes, there's the new Database Manager application:
http://www.iis.net/extensions/databasemanager
At Mix 2009, Microsoft announced this and demoed it. I haven't used it myself, but the demos were gorgeous, and since it's maintained by Microsoft, it's probably the safest bet.

- 4,425
- 18
- 21
-
Looks good ! I'll check it out. – Morph May 02 '09 at 08:50
-
This is built-in to IIS, unlike the web-based interface of phpMyAdmin, right? – Josh Stodola Jan 07 '10 at 17:40
-
No, that's something you have to add - it's pretty similar to phpMyAdmin. – Brent Ozar Jan 12 '10 at 14:35
Weird that no one mentionned myLittleAdmin. This is a 13-year-old project with a robust and stable kernel. Its interface is very similar to SSMS one. And of course it is a full web-based app.

- 121
- 2
SQL Web Data Administrator may be sufficient for what you're looking to do, but it hasn't been updated in about a year and a half. If you need more info, there's a review by SQL Server MVP Jacob Sebastian on SQL Server Central.

- 9,034
- 32
- 33
I've certainly looked for one and haven't found anything decent. However, Rob Allen recently said he is going to try to build one for the European WinPHP Challenge 2009, so it might be worth watching.

- 121
- 1
- 3