Posts
Sort by recent activity
SQL Source Control Certificate Object Signing
Hi,Some of our objects are signed by a certificate (to elevate running permissions to the corresponding certificate user) which is done via a "ADD SIGNATURE TO ?.? BY CERTIFICATE [?]" statement.Is ...
Source control a trigger on a table but not the table structure
Hi,I thought I'd asked this before but perhaps not. On a 3rd party database we'd like to source control out enhancements/modifications but not the vendor-supplied objects. Therefore we filter out ...
Order of changes? Altering tables before stored procedures that reference them?
Hi,I had a CI failure today because in the SCA update script a stored procedure ALTER was done before an ALTER TABLE to add a column that the procedure now referenced.How is the order of changes wo...
Filtered out extended property being included in object script
Hi,If I exclude an extended property by name via the filter, should that prevent the extended property being included in any object scripts that have the property against them? I.e. if I have a st...
Extended property to ignore an object
Hi,For some of our objects, they are automatically scripted in and kept up-to-date from another system, whereas the remainder of the objects are source-controlled manually via SSC.The objects that ...
Preventing prompt to add dependencies (where they are excluded by filter)
Hi,Just thought I'd ask the question in case I'm missing anything. In our environment we we SQL Source Control to source control our company's enhancements (SP, views etc.) which exist within a 3r...
Filter support for LIKE and NOT LIKE?
Hi,In SQL Compare, in the Filter setup you can use LIKE and NOT LIKE criteria, however in SQL Source Control (i.e. the SSMS add-in), it seems to be missing those occasionally useful options.Is ther...
Passing SkipPreUpdateSchemaCheck to Azure Devops "Deploy database changes from a release artifact"
Hi,Is there any way to pass the SkipPreUpdateSchemaCheck to the redgate Azure Devops "Deploy database changes from a release artifact"? It has a checkbox for "Skip post update schema check" but no...
New-DatabaseReleaseArtifact, SQL Source Control and ComparisonOptions.xml
Hi,Is there any way (before I start developing some parsing logic) to use the SQL Source Control (SSC) ComparisonOptions.xml file within its scripts folder to be the comparison options for New-Data...
Removing objects from git repo that have be subsequently filtered in SQL Source Control
Hi,It seems in SQL Source Control (SSC), if you had previously committed an object (say table A), but then later add a Filter into SSC to filter out table A, then the SQL file for table A still rem...