Script out compare/push for all databases

RobertPreseau

Hey all, I'm trying to figure out the best way to push objects from a "gold" copy of our main database out to all clients when an object doesn't exist in the destination.  With SQL Compare I can obviously do this on a one-by-one basis, wasn't sure if there was a way to handle this en masse.

DanC

Hi @RobertPreseau if you have the SQLToolbelt license you can make use of the MultiScript tool. You could generate the update script by connecting to one of the databases and reuse that within the tool to distribute across all the databases you have in your distribution list. 

MultiScript reference: https://documentation.red-gate.com/sms/configuring-sql-multi-script