Esther
4Penny.net
Points: 7600

12/7/2022 8:52:50 AM

SSMS Tools Pack

We don't mind ads here... if they're phrased as introductions to tools that we can use. Often, I'll post a review of my own if it's for something that I think will be valuable to the members... and... I found one. 

SSMS Tools pack. 

I'm buying this for just one feature, but I'm going to enjoy spending the next little while learning all the features. 

Today, specifically: I'm working at a client with 20ish DBs, and 8 of them are production GP databases. I need to publish a SQL SCRIPT FILE to all eight DBs. Note that I said a script file. A file on disk, not a snippet of code. Actually, I have three:

Here's how to run this in all eight DBs, with SSMS Tools Pack:

When it is finished, you get a report

So, so worth the license. 

 

 

 

 

 

4Penny.net
Version: Unknown or N/A
Section: SQL Scripts
Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3