Misc database properties in source control

roryquinnroryquinn Posts: 2
edited September 15, 2015 7:05AM in SQL Source Control Previous Versions
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?

Comments

  • Eddie DEddie D Posts: 1,806 Rose Gold 5
    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 Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: support@red-gate.com
Sign In or Register to comment.