Misc database properties in source control

roryquinn

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?

Eddie D

Hi

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

ALTER DATABASE <DatabaseName>
SET RECURSIVE_TRIGGERS ON

Many Thanks
Eddie