Activity overview
Latest activity by josh_stcu
Thanks, I believe I have been able to successfully adjust our deployment script to account for this. / comments
Thanks, I believe I have been able to successfully adjust our deployment script to account for this.
Path to RedgateDatabaseInfo.xml
We are using the SQL Compare CLI to do state based deployments based on the schema-model folder as defined by Flyway. As I was reorganizing the files to accommodate this, I needed to put the Redgat...
Just echoing that we are also waiting for a fixed version of SQL prompt at our organization as well. / comments
Just echoing that we are also waiting for a fixed version of SQL prompt at our organization as well.
Looks like I just crossed paths with the update notification: I've got v13.0.54 installed and can confirm it has updated the custom alerts. / comments
Looks like I just crossed paths with the update notification: I've got v13.0.54 installed and can confirm it has updated the custom alerts.
Custom Alert Not Clearing
On the lastest version (13.0.53.1762) and I've noticed that at least one custom alert is not clearing: The metric is collected in each user database and runs the following query (returning 1 if the...
So after some actual sleep I need to apologize (and thank you for the magic eyes). We had configured a library variable for the SQL Compare options. Octopus deploy was overwriting the local variable with the default from the library. Was able to retest and confirm that it is working as expected. Thank you! / comments
So after some actual sleep I need to apologize (and thank you for the magic eyes). We had configured a library variable for the SQL Compare options. Octopus deploy was overwriting the local variabl...
@Pete_Ruiz , I have a deployment filter defined and included in the step but it doesn't currently prevent changes to the dbo schema when I deploy. (I've attached the scpf file as a txt) / comments
@Pete_Ruiz , I have a deployment filter defined and included in the step but it doesn't currently prevent changes to the dbo schema when I deploy. (I've attached the scpf file as a txt)
How do force the Octopus Deploy "Deploy From Package" to exclude dependencies?
I can exclude dependencies from pre and post deployment schema checks but I need to ensure that no objects in a dependent schema are deployed through our process as we only actually own/control one...
Actually @AlexYates was came up with the answer I was looking for on SQL Community slack: the path to the alternative filter is absolute (or defaults the working directory). As the filter was in the nuget package we had to use #{Octopus.Action[Package Self Deployment].Output.Package.InstallationDirectoryPath}\db\state\<filter file> which created an absolute path from C:\ to where the tentacle unpacked nuget. / comments
Actually @AlexYates was came up with the answer I was looking for on SQL Community slack: the path to the alternative filter is absolute (or defaults the working directory). As the filter was in th...
We're experiencing something similar I think (although with SQL Change Automation now)? The default filter is being picked up just fine but we have a deployment filter in the same location (db/state/ in the nuget package) we'd like to specify when deploying our package. When we pass in the file name to the Octopus Deploy "Deploy from Package" job step the step will fail with an error that the specified filter cannot be found in the working directory. / comments
We're experiencing something similar I think (although with SQL Change Automation now)? The default filter is being picked up just fine but we have a deployment filter in the same location (db/stat...