Red Gate forums :: View topic - Scripting multiple objects uisng SQL Prompt
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Prompt 6
SQL Prompt 6 forum

Scripting multiple objects uisng SQL Prompt

Search in SQL Prompt 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
redgater



Joined: 20 Dec 2013
Posts: 2

PostPosted: Fri Dec 20, 2013 5:30 pm    Post subject: Scripting multiple objects uisng SQL Prompt Reply with quote

I see that we can right click on an object and select the 'Script object as ALTER' option to script individual objects. Is there anyway to use this option (or any other option with SQL Prompt) to script out multiple objects at once?
Back to top
View user's profile Send private message
David Atkinson



Joined: 05 Dec 2005
Posts: 1123
Location: Twitter: @dtabase

PostPosted: Fri Dec 20, 2013 5:50 pm    Post subject: Reply with quote

What is your use case for this?

You can do this to some extent from the Object Explorer Details page, as multiple object selections are possible from here, and some of the context menu items are available.
Back to top
View user's profile Send private message Send e-mail
redgater



Joined: 20 Dec 2013
Posts: 2

PostPosted: Sat Dec 21, 2013 2:26 am    Post subject: Reply with quote

I want to script out multiple encrypted stored procedures all at the same time. I can do this for unencrypted procedures using the method you mentioned. But the 'Script Objects as ALTER' option provided by SQL Prompt is not available from the object explorer details window. And that is the only option I can use to script encrypted objects.
Back to top
View user's profile Send private message
Aaron Law



Joined: 28 Jun 2013
Posts: 218
Location: Red Gate Software

PostPosted: Sat Dec 21, 2013 10:51 am    Post subject: Reply with quote

Unfortunately I don't think there's an easy way to get to this in Prompt at the moment (although annoyingly we do already have the code in place since you can script multiple invalid objects in the "Find Invalid Objects" page). We do have a related uservoice request for scripting things from the object explorer so please add your vote to it.

In the meantime you could use SQL Compare to create a scripts folder from your database then navigate to the folder and copy the scripts out. A guide for how to do so can be found here.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group