Posts
Sort by recent activity
Post-Deployment Script not working
I created a simple Post-Deployment Script that creates a job, and committed it to Git using SQL Source Control. I confirmed that this is in Git in a new folder Custom Scripts/Post-Deployment. When ...
SQL Source Control will not show new objects on Commit tab
I have somehow gotten myself into the situation where I have new objects in SQL Server that we want to commit, but SQL Source Control will not show them on the Commit tab, rather they all appear as...
SQLCompare as Scheduled Task throws License Not Found error
I am trying to create a scheduled process to update HTML reports using SQL Compare. This works find if I run the process while logged in to the server, but if I try to run it as a Scheduled Task it...
Branching using DLM Automation
We have developed an end-to-end DevOps solution using DLM Automation, TFS, Jenkins, and Octopus Deploy, but our first attempted production deployment was a spectacular failure. Fortunately we had a...
Octopus Tentacle Deployment
i am in the progress of setting up a build server with DLM Automation/Jenkins/Octopus. I am wondering what the best strategy is for deploying the Octopus Tentacles. Is it a best practice to install...
This commit doesn't meet the server's policy requirements...
We have a SQL Server database linked to TFS using SQL Source Control. A new developer successfully linked his development database to the same repository, but when he tries to commit his changes.:
...
Octopus - RedGate - Deploy from Package - Capture update script as artifact
I am using RedGate - Deploy from Package with Octopus. This is working nicely but I would like to capture the update script as an artifact. How can I do that?
DLM Automation with Octopus Deploy
I am doing a PoC with DLM Automation and Octopus Deploy using the DLM Automation Step Templates for Octopus Deploy. My first test is with the template "Red Gate - Deploy from Package. This seems to...
Invoke-DlmDatabaseSchemaValidation - External References
We are trying to use a Jenkins/DLM Automation solution to implement CI for our databases. Many of our database objects reference objects in other databases (either on the same server or on a linke...
Method not found: '!!0[] System.Array.Empty()'
After a successful proof of concept on my local machine I decided to deploy Jenkins and DLM Automation on one of our servers. I now get the following
Invoke-DlmDatabaseSchemaValidation : SQLCompare...