or Create a profile
13 Jun, 2012 04:01 PM
I have spent some considerable time getting the structure of my
SQL DB, views and stored procedures correct on the AppHarbor hosted
I would like to be able to either take a backup of my DB, or
script the whole DB to a .sql file so I can create a copy of it
locally. However, it appears I don't have sufficient rights to
script the DB in one go, but instead have to do each object
Is there any way I can get a copy of my DB either as a backup or
.sql script more easily?
2 Posted by rune on 13 Jun, 2012 10:27 PM
We've build the SQL
Server Bulk copy tool - would that work for your use case?
rune closed this discussion
on 13 Jun, 2012 10:27 PM.
markhodg72 re-opened this discussion
on 14 Jun, 2012 07:24 AM
3 Posted by markhodg72 on 14 Jun, 2012 07:24 AM
Does it copy the views and stored procedures?
4 Posted by friism on 14 Jun, 2012 11:19 AM
The tool only copies data, so you'll have to use the generate
scripts wizard for the other items. Note that you should be able to
select and script multiple items in one go.
Let us know if you can't get that working
5 Posted by markhodg72 on 14 Jun, 2012 12:05 PM
That's the main problem - you can't multi select the stored
procedures to script them. This means I will have to script each
one individually which is going to take ages.
Why are the permissions not set so I can script the whole db
Is there another way to do this in one go, or do I have to
manually script each stored procedure/view?
6 Posted by friism on 14 Jun, 2012 12:28 PM
Hi Mark, I remember now - you need to leave out Roles and
Schemas as mentioned here:
markhodg72 closed this discussion
on 18 Jun, 2012 03:05 PM.
Comments are currently closed for this discussion.
You can start a new one.
3 people watching.
No more actions from AppHarbor or the discussion starter are required.
This discussion is private.
Only you and AppHarbor support staff can see and reply to it.
This discussion is public. Everyone can see and reply to it.
Powered by Tender™.