Database options (e.g.BROKER_ENABLED) not handled by SC
vls
Posts: 4
Hey,
so far I didn't find any solution on how to include database option properties under SC using RedGate. I din't find them under Setting SQL Compare options within SQL Source Control and writing a migration script is not an option.
For example there is option to keep Service Broker objects under SC, but no option to keep BROKER_ENABLED option on db.
Thanks for any advice.
so far I didn't find any solution on how to include database option properties under SC using RedGate. I din't find them under Setting SQL Compare options within SQL Source Control and writing a migration script is not an option.
For example there is option to keep Service Broker objects under SC, but no option to keep BROKER_ENABLED option on db.
Thanks for any advice.
Comments
SQL Source Control sort-of works under the assumption that the database will be created by hand, so it does not script dboptions.
If you are interested in seeing this added to the software, feel free to put it on the list of suggestions at http://redgate.uservoice.com/forums/390 ... ce-control