Script out compare/push for all databases

RobertPreseau · March 3, 2020 1:58PM

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 · March 4, 2020 4:28PM

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

Script out compare/push for all databases

Answers

Product Learning

Community Forums

Events & Friends

Simple Talk