I work a lot with MySQL and have no experience with SQL Server. But I have an upcoming project where the existing site database is located on SQL Server. I will need to periodically look at an existing database to make SQL dumps the most likely, so I can write a script migration to a new site database in MySQL. The client will regularly update this existing database, so simply requesting a one-time dump will not help.
Ideally, I am looking for a web-based tool (or desktop) that will allow me to log into the SQL Server database (I have remote access) and allow me to dump or possibly view the database structure. Something similar to phpMyAdmin would be nice.
Update: I have to clarify that ASP-based web tools are not perfect. As far as I would like to learn more about ASP, I don’t have time to set up another environment just to run the tool. Something arranged by a third party will do the trick.
source share