Web-based, hosted admin tool for SQL Server database access [closed]
Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and what has been done so far to solve it.
Closed 9 years ago.
Improve this questionI work extensively with MySQL and have no experience with SQL Server. But I have an upcoming project where the existing site's database is on SQL Server. I will be needing to make periodic glances at the existing database, to make SQL dumps most likely so I can write a migration script to the new site database in MySQL. The client will be regularly updating this existing database so just asking for a one-time dump will not help.
Ideally I am looking for a web-based (or desktop based) tool which will allow me to log in to the SQL Server database (I have remote access) and allow me to make a dump or perhaps browse the database structure. Something similar to phpMyAdmin would be nice.
Update开发者_如何学运维: I should clarify that web-based tools which are ASP based are not ideal. As much as I'd like to learn more about ASP, I do not have the time to set up another environment just to run the tool. Something hosted by a 3rd party would do the trick.
Several options are available (probably quite a few more, too):
- SQL Web Data Administrator
- SQL Server Web Tools
- Article on web based admin tools
- CiberSQL Web Admin
- myLittleAdmin (commercial)
- SqlWebArchitect
- MSSQL Web Admin (broken link)
- DBHawk (commercial)
You can also connect via ODBC to your remote MSSQL server then use MSAccess or OpenOffice to connect, browse or backup.
精彩评论