Comments
Sort by recent activity
Ah, I see. With SQL Source Control, the behavior is that it provides a standardized way of committing the files. But these are not designed to be deployment scripts -- for many object types (tables, etc), that wouldn't work at all. There are a few options to configure deployments for SQL Source Control projects. I don't know if your app development team holds licenses for SQL Compare or any other Redgate products, but if they do then there are options for them to create deployment scripts which include those re-runnable headers in them -- but this does require having SQL Compare or another tool to create those deployments. Happy to help give more detail on those if that would be helpful. Cheers, Kendra / comments
Ah, I see.With SQL Source Control, the behavior is that it provides a standardized way of committing the files. But these are not designed to be deployment scripts -- for many object types (tables,...
Hi Peter, We do support the same project being worked on in both plugins. The SSMS plugin has no concept of a solution and creates a fairly minimal project -- just what SCA needs to get things done. If you create a project in SSMS and commit it, then open it in Visual Studio, Visual Studio will add some extra files to source that it will want to commit. These shouldn't create a problem when working with the project in SSMS, however. I believe this is the main difference. Cheers, Kendra / comments
Hi Peter,We do support the same project being worked on in both plugins.The SSMS plugin has no concept of a solution and creates a fairly minimal project -- just what SCA needs to get things done. ...
Hi Peter, Aha, I see! So to make this work, I believe you would need the ability to have Azure Active Directory authentication on the build task. We do support Azure Active Directory password authentication on building, but currently this option isn't available in the graphical plugin in Azure DevOps. If you are open to switching that step to a powershell step to do the build, you could test it out that way. The powershell build would use New-DatabaseConnection to specify the authentication when connecting and pass this connection into Invoke-DatabaseBuild. Then you'd need to call New-DatabaseBuildArtifact followed by Export-DatabaseBuildArtifact. Is that of interest to you? Totally understand if you decide to go with plan b instead. For longer term, we do have a prioritized ticket open to add Azure Active Directory Password authentication to the Azure DevOps build task itself based on a separate customer request. I added a comment to the ticket mentioning that you are an additional customer who would find this useful. Cheers, Kendra / comments
Hi Peter,Aha, I see! So to make this work, I believe you would need the ability to have Azure Active Directory authentication on the build task. We do support Azure Active Directory password authen...
And sorry, reading this I see that it's EXTERNAL USER and not external tables. I clearly have external tables on my mind! I think overall the general notes /approach is the same. It might be complex if those user accounts own objects, but otherwise might be relatively simple. / comments
And sorry, reading this I see that it's EXTERNAL USER and not external tables.I clearly have external tables on my mind!I think overall the general notes /approach is the same. It might be complex ...
Hi @gail123, We are looking to improve on this functionality and make the ability to deploy from SQL Source Control via migrations much smoother. Would you be open to me emailing you about possibly participating in a preview of a new tool? Cheers, Kendra / comments
Hi @gail123,We are looking to improve on this functionality and make the ability to deploy from SQL Source Control via migrations much smoother.Would you be open to me emailing you about possibly p...
Hi @SimonBarnes, I suspect that this is possible to update by:
Unlinking the static data
Committing
Relinking the static data
Did you happen to test that way with a commit between unlink and relink? (I haven't tested this exact scenario, but in working with other scenarios I have found that pattern causes the static data file to be regenerated.) Kendra / comments
Hi @SimonBarnes,I suspect that this is possible to update by:
Unlinking the static data
Committing
Relinking the static data
Did you happen to test that way with a commit between unlink and relink?...
@LouisSomers thank you so much for following up and posting the solution! / comments
@LouisSomers thank you so much for following up and posting the solution!
Hi @LouisSomers, Does the user account which the build is running under have db_owner permission for the database? Here is our guidance on permissions for the build with the different options: https://productsupport.red-gate.com/hc/en-us/articles/360016293733-SQL-Change-Automation-Powershell-permissions Hope this helps, Kendra / comments
Hi @LouisSomers,Does the user account which the build is running under have db_owner permission for the database? Here is our guidance on permissions for the build with the different options: https...
Hi BlueBSH, I am guessing this is a build for a SQL Source Control project in SQL Change Automation. I suspect that the way to solve it this is to filter the function and handle it in a pre-deployment script, but it's hard for me to say without seeing the exact schema of the objects involved. If you'd prefer to share the schema in a private way / not in a public forum, I'd encourage you to start up a support ticket so we can help with more detail. Kendra / comments
Hi BlueBSH,I am guessing this is a build for a SQL Source Control project in SQL Change Automation.I suspect that the way to solve it this is to filter the function and handle it in a pre-deploymen...