Activity overview
Latest activity by vfrank66
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...
dbo role or db_owner? I agree with Dlyes, and am having the same issue where permissions outside of sysadmin seem to fail. My error with SQL Change Automation Build - Build database project from source control throws an error "login failure" (abbreviated). I know the account can login so the error should be more helpful like cannot apply security permissions. / comments
dbo role or db_owner? I agree with Dlyes, and am having the same issue where permissions outside of sysadmin seem to fail. My error with SQL Change Automation Build - Build database project from so...
I have read that first article. But okay here is an example, mistake by a teammember of mine and they checked in permissions, while the DLM Automation task to build a database package fails because the role does not exist on an object whose permissions were checked in. What should be done to prevent that? Check in filters? What if the dev mistakenly doesn't have them, what is the recommendation on this? / comments
I have read that first article. But okay here is an example, mistake by a teammember of mine and they checked in permissions, while the DLM Automation task to build a database package fails because...
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...
I am using this in day-to-day SQL development. But as a younger DBA I am not constrained to old habits.
Although SqlOps is still not at v1 I would like to see this tool investigated again for Redgate. Some days our CI requires me as a DBA to jump through SSMS, DLM Dashboard, and lastly Powershell to ensure I correct a problem in deployment. SqlOps offers the extensiblity to allow me stay within one tool. Possibly adding a custom dashboard which mimicks DLM Dashboard within SqlOps.
I think the most important thing for me is that one of my databases in source control have so many objects that we run into the SSMS x32 bit issues. Just "getting latest" causes memory issues requiring our team to use the Large Address Aware app, disable some other Redgate extensions, and SSMS intellisense in order issue a Redgate source control "Get Latest". This causes lots of slowness and disruption to development, devs and DBAs. This could be a tool which offers a GUI way solution to that problem. / comments
I am using this in day-to-day SQL development. But as a younger DBA I am not constrained to old habits.
Although SqlOps is still not at v1 I would like to see this tool investigated again for Redga...
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...