How can we help you today? How can we help you today?

Misc database properties in source control

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?
roryquinn
0

Comments

1 comment

Sort by
  • 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
    Eddie D
    0

Add comment

Please sign in to leave a comment.