Posts
Sort by recent activity
DB permissions required
In the " Deploy database changes from from artifacts" step..what are the permissions required by the Account (either windows authentication or SQL authentication" ) on the target DB and target DB s...
Baseline script giving errors
I created a baseline script for one of my DBs and it didnt generate proper script for Default Constraints. Please see belowCREATE TABLE [DCST].[XREF_REL_SETTLEMENT_COMPLAINT]([SETTLEMENT_KEY] [int]...
MigrationLog - Deployed column
What are the different values in Deployed column specify? I see 0,1,2. I didnt find any documentation on this. Any help would be appreciated.
Losing Migration Log
My understanding is that MIgrationId of MigrationLog table is key which drives the entire release cycle of a script across environments. Since MigrationLog is created under a DBO schema and since m...
Restrict Objects getting dropped accidently
Is there a way we can force the Deployment step to throw a warning or throw error if it finds any drop statements? This is to make sure there are no accidental "drops" / "deletes" going into produc...
Setting CI/CD
Do we still need to follow Option C from the below link for SQL Change automation?https://documentation.red-gate.com/rr1/installing/build-components?_ga=2.62149039.225767399.1530212148-1461734100.1...