MS Sql Database backup and restore
Hi
Can I backup and restore ms sql databases?
What tool/procedure should I use?
Thanks!
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
Support Staff 1 Posted by tt on 17 Feb, 2011 09:30 PM
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.
tt closed this discussion on 17 Feb, 2011 09:30 PM.
rodrigojuarez re-opened this discussion on 20 Feb, 2011 10:52 AM
2 Posted by rodrigojuarez on 20 Feb, 2011 10:54 AM
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!
Support Staff 3 Posted by friism on 20 Feb, 2011 11:02 AM
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.
friism closed this discussion on 20 Feb, 2011 11:02 AM.
friism re-opened this discussion on 24 Feb, 2011 06:30 AM
Support Staff 4 Posted by friism on 24 Feb, 2011 06:30 AM
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.
friism closed this discussion on 24 Feb, 2011 06:30 AM.