What SQL Server2017 features Does Redgate Source Control not do?

Bluecar85

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

Tianjiao_Li

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.

Bluecar85

that's strange Redgate does not support such Critical Database properties, should I just set them as Post-Deployment scripts then?

Bluecar85

Hi Redgate, Please send me a workaround solution then-

Bluecar85

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

GreenCar91

posted question here, on Stack https://dba.stackexchange.com/questions/217458/redgate-does-not-source-control-sql-server-database-properties

Tianjiao_Li

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