Getting access to SQL DB
I have spent some considerable time getting the structure of my SQL DB, views and stored procedures correct on the AppHarbor hosted SQL server.
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 individually.
Is there any way I can get a copy of my DB either as a backup or .sql script more easily?
Comments are currently closed for this discussion. You can start a new one.
Support Staff 2 Posted by rune on 13 Jun, 2012 10:27 PM
Hi,
We've build the SQL Server Bulk copy tool - would that work for your use case?
Best,
Rune
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?
Support Staff 4 Posted by friism on 14 Jun, 2012 11:19 AM
Hi Mark
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
Michael
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 myself?
Is there another way to do this in one go, or do I have to manually script each stored procedure/view?
Support Staff 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: http://support.appharbor.com/discussions/problems/1209-sql-script-g...
Michael
markhodg72 closed this discussion on 18 Jun, 2012 03:05 PM.