Home / server / Questions / 282881
Accepted
Tedd Hansen
Asked: 2011-06-22 22:43:22 +0800 CST

Equivalent of phpMyAdmin for MSSQL?

  • 772

Is there any webinterface for administrating MSSQL similar to phpMyAdmin (for MySQL)?

I want a self-service setup where developers can create a database through webinterface and upload/download backups of the database without local access.

I've considered phpMSAdmin, but it hasn't had a release since 2006 so I'm not sure its worth the effort of setting it up. If there is something else (free or not-so-free) that would be great.

My question is similar to this one posted 2 years ago, but no good webinterface was found back then. SQL Web Data Administrator seems interesting, but it lacks a few features - most notably creating new databases (also, not updated since 2007).

sql-server remote-access web-applications

3 Answers

  1. Best Answer

    There is MyLittleAdmin that we use. I find it strange that it's not been mentioned here. We've used it for years and I think our developers find it works well for them. I think it's crazy that there's not a official web based tool like phpMyadmin for MSSQL. I don't want to give our developers access to our production SQL Servers so a web based solution is ideal for us.

    • 6

  2. There's no default web interface like phpMyAdmin. Typically you wouldn't want to expose your Microsoft SQL Servers to the public net. You would normally connect via VPN then use SQL Server Management Studio to connect.

    The web interfaces that you found will probably do the trick, but without providing access to some of the newer features. If you are just looking for basic functionality those will work just fine. The nice thing about SQL Server is that anything you can do in SSMS you can do in T/SQL so if the web interface you have doesn't provide functionality you can still manage and use those features using T/SQL.

    • 4

  3. As mrdenny says, there is no default web interface for mssql. And I rather not use third party program that hasn't released update since more than 3 years... pretty dangerous if the security isn't improved.

    As form me, I use RazorSQL for my database managing. It's a good tool, you just have to create a connection (ip, port, databasename, and so on...) And you can interact with your database, you can do almost anything (if you're connected as root), a very complete tool. But it's not as friendly as phpmyadmin, but still better (well, at least for me.)

    Give it a try.

    • 0