Red Gate forums :: View topic - How to list a group of script and apply it depending on the
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Multi Script 1
SQL Multi Script 1 forum

How to list a group of script and apply it depending on the

Search in SQL Multi Script 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
Nehal.Shah



Joined: 09 Sep 2008
Posts: 8

PostPosted: Tue Nov 18, 2008 7:31 am    Post subject: How to list a group of script and apply it depending on the Reply with quote

Hi,

We are having license copy of SQL Compare and multiscript.

We have one requirement which I don’t know how to achieve.
We need to upgrade database when we want to upgrade to higher version.
For this we have sets of SQL queries that needs to be applied before SQL Compare and synchronies.
Now this set varies depending on the version to which we want to upgrade the database.
i.e. if we want to update it to
Version 1.1 – 6 sql scripts needs to be applied,
Version 1.2 – 9 sql scripts needs to be applied,
Version 1.3 – 8 sql scripts needs to be applied and so on.

If we use SQL Multi Script than each time we have to select that many scripts.
Instead of this if we have file containing list of this script than on loading this file all the sql script should load.

Can you suggest solution for the above situation?

Thanks
Mr Nehal Shah

PS: Let me know if i am in the wrong forum.
Back to top
View user's profile Send private message MSN Messenger
Colin Millerchip



Joined: 31 Oct 2007
Posts: 66
Location: Cambridge, UK

PostPosted: Thu Nov 20, 2008 12:03 pm    Post subject: Reply with quote

Hello Mr. Shah,

I believe what you're asking for is something that we've been referring to internally as "projects" -- ie, a way of remembering the lists of scripts, their execution order, the target databases and other settings, for easy re-use. This isn't currently supported within SQL Multi Script 1.1, but is something we're considering for a future release. However, it's currently possible to drag and drop scripts from Windows Explorer into SQL Multi Script; so if you are able to easily identify the scripts within Windows Explorer (eg, have them all together within a folder), then this might be of some help.

At the moment, I'm running a survey to collate feedback from as many people as possible on how they use SQL Multi Script, and how they'd like to see it enhanced in the future. If you have a few minutes spare, please add your views and opinions to the survey -- it's at:

https://www.surveymk.com/s.aspx?sm=fRLJ8ET4RKa8Ea80cgiQSQ_3d_3d

(this survey is mentioned in a forum post here).

Best regards,


Colin.
Back to top
View user's profile Send private message Send e-mail
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