Activity overview
Latest activity by Shaggy
Build Issue - No RedGateDatabaseInfo.xml file found in root folder...
NEVER MIND - We fixed it. - Subfolder path wasn't pointing to db/state.We started receiving the following error message on one of our builds. This is the 1st occurrence as we've been using SQL Cha...
Thanks for sharing your experience cjoneslib. We abandoned our POC of this product in Q1. Reverted back to SQL Source Control for all database repos. I've been stalking the release notes every month to see if the product changes to address our issues. Our team would really like to use it due to all of the other benefits. However, this issue is a blocking obstacle for us. / comments
Thanks for sharing your experience cjoneslib. We abandoned our POC of this product in Q1. Reverted back to SQL Source Control for all database repos. I've been stalking the release notes every m...
Thanks Kendra & Pete. The combo of your responses illustrates how we can effectively deal with the scenario. Going forward do you recommend the SCA/migrations approach or the SOC/state approach when multiple developers (3-6) are actively working in the database project? Note: We've been using the SOC/state approach for 2-years, and we are currently evaluating SCA/migrations on a greenfield project. Kicking the tires so to speak before converting. / comments
Thanks Kendra & Pete. The combo of your responses illustrates how we can effectively deal with the scenario. Going forward do you recommend the SCA/migrations approach or the SOC/state approach w...
How to address resolve merge conflicts in the .sqlproj <DeployChangesExecutionOrder> line?
Scenario:Consider the following sequential timeline of events:
Dev A - creates branch (BR1) from master.
Dev B - creates branch (BR2) from master.
Dev B - creates a stored procedure in BR2, genera...
@Kendra_Little Were the developers able to address my question? / comments
@Kendra_Little Were the developers able to address my question?
Latest Patch Download
Hello,We are interested in keeping up with the latest version of the PowerShell module. It's for our Octopus Deploy server, otherwise we would simply download the toolbelt. Is the installer for t...
My filter and compare options are attached for reference. I am building in Microsoft Visual Studio Team Foundation ServerVersion 15.117.27414.0 Running SQL Change Automation:Build v3.1. / comments
My filter and compare options are attached for reference. I am building in Microsoft Visual Studio Team Foundation ServerVersion 15.117.27414.0Running SQL Change Automation:Build v3.1.
Hello Kendra, I executed your SQL in my environment and it failed with the following message: 2019-02-07T15:59:14.4268592Z ##[warning]The error 'The object 'dbo.duplicate' does not exist or is invalid for this operation.' occurred when executing the following SQL: 2019-02-07T15:59:14.4268592Z ##[warning]CREATE TRIGGER [dbo].[tr_duplicate] ON [dbo].[duplicate] AFTER INSERT AS 2019-02-07T15:59:14.4268592Z ##[warning]BEGIN 2019-02-07T15:59:14.4268592Z ##[warning]DELETE FROM dbo.duplicate WHERE 1 = 0 2019-02-07T15:59:14.4268592Z ##[warning]END / comments
Hello Kendra,I executed your SQL in my environment and it failed with the following message:2019-02-07T15:59:14.4268592Z ##[warning]The error 'The object 'dbo.duplicate' does not exist or is invali...
SQL Change Automation - Create Trigger Failure & TVPs
Does SCA distinguish between table & TVP objects with the same name?The build fails when attempting to create a trigger object on a table when a table-valued-parameters exists with the same name. ...
We invoked the desired behavior for scenario #3 by changing this option to false: <IgnoreDatabaseAndServerName>False</IgnoreDatabaseAndServerName> Can you confirm if this is valid/safe? / comments
We invoked the desired behavior for scenario #3 by changing this option to false:<IgnoreDatabaseAndServerName>False</IgnoreDatabaseAndServerName>Can you confirm if this is valid/safe?