Misc database properties in source control
roryquinn
Posts: 2
I've been working on building my databases from source control and when I sync my nuget packages my databases do not have recursive triggers enabled. Is there a way to add this and other database properties into source control so my databases have this property set correctly?
I find a way to add this in the UI, however I did notice that some properties like default collation are saved in RedGateDatabaseInfo.xml. Would this be something I can add manually to this file to track these properties?
I find a way to add this in the UI, however I did notice that some properties like default collation are saved in RedGateDatabaseInfo.xml. Would this be something I can add manually to this file to track these properties?
Comments
Thank you for your forum post and sorry for the delay in replying back to you.
I believe one of my colleagues answered your question in support call #48892, with the following:
Add an extra step before the sqlci sync which runs the following SQL
Many Thanks
Eddie
Senior Product Support Engineer
Redgate Software Ltd
Email: support@red-gate.com