Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I need to export some tables in a MS SQL database.

The ASP.NET Enterprise Manager provided by the host doesn't offer much functionality. Can someone recommend a good program for doing this?

I only have FTP and Control Panel access to the account.

I tried phpMSAdmin but it's not working.

share|improve this question

1 Answer 1

up vote 0 down vote accepted

You don't mention which version you are (your host is) running. Also, are you looking for a "permanent" fix, as "I'm migrating to a new host", or just "I need to regularly export my {insert app here} data to another app"?

Probably the simplest answer is to write it yourself: any language that can query the database could be used to write it to anywhere else (another database, CSV, HTML, etc) ...

Does your FTP access let you get to the actual files (usually database_name.mdf and database_name.ldf)? If so, you could (if the admin console lets you) detach the database, copy the files, and attach them to a local instance. A related tactic would be to run a backup, bring the backup files over, and restore them to a local instance.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.