Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
 Posted - 2008-02-18 : 11:24:56
|
I am searching for an add-in to ssms which lets me choose which server to deploy my code.For example, I have a complete statement with CREATE PROCEDURE and all code in my query window.Now I want to run/deploy this code to many servers at once.Instead of having to reconnect to all server (5), I want an add-in which have checkboxes for me to select.Anyone heard of this?
E 12°55'05.25"N 56°04'39.16" |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-02-18 : 11:30:02
|
| Seems like next major feature for Spirit's SSMS tool pack!http://www.ssmstoolspack.com/Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
jdaman
Constraint Violating Yak Guru
354 Posts |
Posted - 2008-02-18 : 11:33:31
|
| I think I came across a solution from embarcadero that does what youre asking while I was looking at data modeling tools but dont remember for sure: http://www.embarcadero.com/ |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-02-18 : 11:42:06
|
If Mladen wants to, sure!I want a complete set of all registered servers and all their databases to select a checkbox.And when clicking OK, I want the highlighted code, or complete window to be executed for all checked checkboxes.
E 12°55'05.25"N 56°04'39.16" |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2008-03-04 : 09:14:17
|
| the problem with this is that for every server you'd have to provide a username and password each time, since the registered servers can "forget" their passwords.redgate has a tool that does this... can't remember the name.i'll see what i can come up with though.. interesing request though._______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenpSSMS Add-in that does a few things: www.ssmstoolspack.com |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-03-05 : 04:31:56
|
Excellent!But that takes script files. I want to run adhoc, with the code in my query window...
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
Searching for Add-In