What features does Redgate Source control not conduct?
Does it source control the following, and anything else I am missing? I know yesterday, it did not notice our change to db property Read Committed Snapshot, which is highly important?
how about these ones below? Anything else I am missing?
db properties (ansi null, quoted identifier)
Transaction Isolation Level (Read Committed, Snapshot Isolation, etc)
Encryption,
certificates,
partitions
Comments
6 comments
-
Hi @Bluecar85
I'm afraid all database level settings and properties are not supported by SQL Source Control...
If you'd like them to be supported, can you kindly post your suggestion on our user voice forum?
Table partitioning is supported and you need to uncheck ignore "Filegroups, partition schemes and partition functions".
SQL Source Control doesn't support synchronising certificates and symmetric keys:
That's why the default options is to ignore them. If you uncheck the ignore option, you still can view it in Commit page but you won't be able to check in it.
-
that's strange Redgate does not support such Critical Database properties, should I just set them as Post-Deployment scripts then?
-
Hi Redgate, Please send me a workaround solution then-
-
Can you send me a complete list of Red Options, Properties not supported in source control? We have a Major Enterprise, and want to be sure with No Surprises, before purchasing
-
posted question here, on Stack https://dba.stackexchange.com/questions/217458/redgate-does-not-source-control-sql-server-database-properties
-
Hi @Bluecar85
Sorry for the inconvenience caused.
In this case, you can use the pre and post-deployment scripts. Please have a look of the following page for more detials:
https://documentation.red-gate.com/soc6/common-tasks/working-with-pre-post-deployment-scripts
Add comment
Please sign in to leave a comment.