MS Sql Database backup and restore

rodrigojuarez's Avatar

rodrigojuarez

17 Feb, 2011 04:42 PM

Hi
Can I backup and restore ms sql databases?
What tool/procedure should I use?

Thanks!

  1. Support Staff 1 Posted by tt on 17 Feb, 2011 09:30 PM

    tt's Avatar

    We offer full connectivity with SQL Server Management Studio and other tools should be able to connect to the database as well, from outside the AppHarbor environment.

    We do nightly backups of all databases though and keep those for a week, so it shouldn't be necessary. At the moment, we don't offer access to the backup files, but feel free to suggest it.

  2. tt closed this discussion on 17 Feb, 2011 09:30 PM.

  3. rodrigojuarez re-opened this discussion on 20 Feb, 2011 10:52 AM

  4. 2 Posted by rodrigojuarez on 20 Feb, 2011 10:54 AM

    rodrigojuarez's Avatar

    Hi
    I can connect via Sql Server Management Studio, but can I restore a database from my computer? Any tool that can do the work?
    Thanks!

  5. Support Staff 3 Posted by friism on 20 Feb, 2011 11:02 AM

    friism's Avatar

    You cannot currently restore a database from a backup on AppHarbor. We are trying to come up with good ways to move data on and off AppHarbor SQL Servers. In the meantime, if your database is of moderate size, you can script both database schema and data on you local machine and execute that on your AppHarbor database.

  6. friism closed this discussion on 20 Feb, 2011 11:02 AM.

  7. friism re-opened this discussion on 24 Feb, 2011 06:30 AM

  8. Support Staff 4 Posted by friism on 24 Feb, 2011 06:30 AM

    friism's Avatar

    We've written a console app that you can use to copy data between SQL Server databases. Get the code on GitHub and check out the blog post.

  9. friism closed this discussion on 24 Feb, 2011 06:30 AM.

Discussions are closed to public comments.
If you need help with AppHarbor please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac