Posts
Sort by recent activity
VSTS Build extension - Build a SQL Source Control Project Target CI DB Permissions
I was reading this documentation and trying to figure out the least privileges I can grant the account which runs a VSTS build task "Build a SQL Source Control project". I would like to not use Loc...
Resource for Ignoring Database Permissions
Is there a good resource for dealing with Database Source Control permissions.I am trying to run "Redgate DLM Automation" task in VSTS, it keeps failing saying a role has not been created. I believ...
Redgate SC not picking up a deleted proc in Live database
Redgate 6.0.2.6908Windows 10SSMS 16 - 13.0.16106.4git working folderFirst step was restore the database from a backup and then unlink and relink the database. Next, I deleted a stored procedure fro...
How do you handle static data foreign key constraints to non-static data in Invoke-DlmDatabaseSchema
I have static data in about 100 tables in a over normalized database. Some of the static data tables reference in foreign keys to non-static data. When running Invoke-DlmDatabaseSchemaValidation th...
Linked Server Failure with Invoke-DlmDatabaseSchemaValidation
$scriptsFolder = "C:\Repo\Database"
$options = "IgnoreComments, ObjectExistenceChecks, IgnoreUsersPermissionsAndRoleMemberships"
$temporaryDatabase = New-DlmDatabaseConnection -ServerInstance <ser...
How do you populate a drop down in a .rgtool file?
I am trying to create a script that allows someone to choose the server, database, and snapshot to rollback to. I can see
<control type="database" id="connection" />
will create a drop down to cho...