35

I am looking for web based tool like phpMyAdmin, but for SQL Server. Any suggestions?

John Saunders
  • 160,644
  • 26
  • 247
  • 397
Balchev
  • 1,104
  • 2
  • 11
  • 17

5 Answers5

17

This works and is under active development: http://www.adminer.org/

iss42
  • 2,720
  • 3
  • 21
  • 37
  • 4
    On Debian, Ubuntu: `apt-cache search adminer` > `adminer - Web-based database administration tool` `sudo apt-get install adminer` open browser at `http://localhost/adminer` or whatever host you've installed it on. Works out of the box. Very cool. – knb Jul 09 '13 at 08:15
  • 4
    One simple php file, no setup needed, works like a charm. Compares itself to myPhpAdmin and touts better features. Using it on IIS with Sqlsvr 2012. Handles all sorts of databases. Super easy to use. Exactly what I was looking for. – Brainware Apr 22 '14 at 23:55
10

I've also found this product which seems to support SQL Server

John Saunders
  • 160,644
  • 26
  • 247
  • 397
MaxiWheat
  • 6,133
  • 6
  • 47
  • 76
3

You could try some thing from the list provided by Microsoft. Microsoft also apparently has a web admin, but it's rather old from what I can see. I'm interested in this area as well, so please report back on your conclusions.

cofiem
  • 1,384
  • 1
  • 17
  • 29
  • Well, web has limited features so I wouldn't suggest this one. Instead of it, if you have money then purchase something really working. – Tarik Oct 01 '09 at 07:55
2

-THIS MIGHT NOT BE THE ANSWER TO YOUR QUESTION-

if you have sql server managment studio(its free) you can connect to a SQL Server database remotely

John Saunders
  • 160,644
  • 26
  • 247
  • 397
Hannoun Yassir
  • 20,583
  • 23
  • 77
  • 112
  • 1
    I know and I think the person asked this question also knew. However, with phpmyadmin, you could access the database from any computer. Without the web-based system like that, you will have to install the software on every computer you want to access to the database. Yet, in some cases you also need to add your client ip to the firewall exception on the server. With things like phpmyadmin, you never have to do it. – Quan Feb 23 '17 at 22:15
2

I do not want to make self-ad, but definitively myLittleAdmin is what you're looking for. Note most of the serious windows webhosting companies are providing myLittleAdmin as a service to all their customers who use MS SQL databases.