tag:support.appharbor.com,2010-11-23:/discussions/problems/4888-getting-access-to-sql-dbAppHarbor: Discussion 2012-06-18T15:05:02Ztag:support.appharbor.com,2010-11-23:Comment/166369902012-06-13T22:27:40Z2012-06-13T22:27:40ZGetting access to SQL DB<div><p>Hi,</p>
<p>We've build the <a href=
"https://github.com/appharbor/AppHarbor-SqlServerBulkCopy">SQL
Server Bulk copy tool</a> - would that work for your use case?</p>
<p>Best,<br>
Rune</p></div>runetag:support.appharbor.com,2010-11-23:Comment/166369902012-06-14T07:24:30Z2012-06-14T07:24:30ZGetting access to SQL DB<div><p>Does it copy the views and stored procedures?</p></div>markhodg72tag:support.appharbor.com,2010-11-23:Comment/166369902012-06-14T11:19:41Z2012-06-14T11:19:41ZGetting access to SQL DB<div><p>Hi Mark</p>
<p>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.</p>
<p>Let us know if you can't get that working<br>
Michael</p></div>friismtag:support.appharbor.com,2010-11-23:Comment/166369902012-06-14T12:05:27Z2012-06-14T12:05:27ZGetting access to SQL DB<div><p>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.</p>
<p>Why are the permissions not set so I can script the whole db
myself?</p>
<p>Is there another way to do this in one go, or do I have to
manually script each stored procedure/view?</p></div>markhodg72tag:support.appharbor.com,2010-11-23:Comment/166369902012-06-14T12:28:31Z2012-06-14T12:28:31ZGetting access to SQL DB<div><p>Hi Mark, I remember now - you need to leave out Roles and
Schemas as mentioned here: <a href=
"http://support.appharbor.com/discussions/problems/1209-sql-script-generation-fails">
http://support.appharbor.com/discussions/problems/1209-sql-script-g...</a></p>
<p>Michael</p></div>friism