Command Line Prompt Deploy to multiple DB at the same time.

jamesytl

Hi,

I'm new to redgate and wish to ask something.

I have read the https://documentation.red-gate.com/display/SC12/Simple+examples+using+the+command+line and understand that I can use command prompt to deploy table structure changes to other DB.

However, what I really want to accomplish is to deploy more than 1 DB at the same time.

Example : sqlcompare /Database1:WidgetStaging /Database2:WidgetProduction /Database3:WidgetProduction /Database4:WidgetProduction.... /Synchronize

Is it possible to do so?

Advise and help are much appreciated.

sam.blackburn

SQL Compare only deploys to one database at a time. If you wanted to run exactly the same script on multiple databases you could use SQL Multiscript, but if you want to generate a tailored deployment script for each database it would probably be better to call SQL Compare in a loop.

jamesytl

Use cmd compare two db -> generate deployment script based on db structure difference (not data) -> output deployment script to a folder

Is it possible to carry out the flow I mentioned above? If yes what is cmd needed to generate the script.

I will just go for my own multi-db deployment way if the flow above can work.