Activity overview
Latest activity by TimothyCloud
Excellent news. Thanks Alex. I am getting some results using PowerShell scripts to deploy the NuGet package that Bamboo and Redgate DLM create, so I think I'm getting close. I'll also be in touch concerning further training. / comments
Excellent news. Thanks Alex. I am getting some results using PowerShell scripts to deploy the NuGet package that Bamboo and Redgate DLM create, so I think I'm getting close. I'll also be in touc...
Ok, I will mention classes to the customer, however they have a new hire DBA onboarding in early February, so would love to know your schedule for around that time and and deals we could get on 3-4 seats for the DLM Automation Continuous Integration stuff. The only tool we have committed to is Redgate. So, using Bamboo, Octopus, Jenkins, Whatever is all an option if a solid case can be made for ROI of such tools for their particular company. Let me tell you a little about what I have done so far:
1.) On 1 server, I have manually deployed all their databases using a repository and SQL Source control.
2.) I have been given another server instance of SQL to try and "deploy" to as a target.
3.) On my 1 server, I installed RedGate DLM Automation, Bamboo, Octopus and considering Team City.\
4.) On my target server, I don't have access beyond SQL Server, and I need to know if that is my next request from the customer?
What we are attempting is to have an automated Build of the database stored in Redgate Source Control onto a server which has never ran anything other than SQL Server. Is that even possible?
Thanks! / comments
Ok, I will mention classes to the customer, however they have a new hire DBA onboarding in early February, so would love to know your schedule for around that time and and deals we could get on 3-4...
Am I looking for SQL Compare along with DLM Automation using Bamboo for my scenario? / comments
Am I looking for SQL Compare along with DLM Automation using Bamboo for my scenario?
So right now, I'm just trying to achieve a proof of concept mainly.
I have a database, actually several of them, that I am attempting to get Bamboo to Build, Test, Deploy into another SQL Server environment. I get the build process done...not as concerned about TEST yet, but I need the results of that build (which I store locally as a NuGet package) to now deploy on another SQL Server that is not local to the Bamboo server. Isn't there a way I can do that using the Command Line or Powershell or similar method? That's my next step. Build--<maybe test>--Deploy then I will come back and start working on putting something like that to work in a real task, such as...developer creates new stored proc and puts it into SQL Source Control....trigger is fired to automate the Bamboo Build and Test and Deploy into PreProd....and then I'll really need some help I would imagine. [image] / comments
So right now, I'm just trying to achieve a proof of concept mainly.
I have a database, actually several of them, that I am attempting to get Bamboo to Build, Test, Deploy into another SQL Server en...
I feel like I'm so close, but somehow I'm missing something. For example, do I need to download and install NuGet in order for Bamboo to create the NuGet artifact? Once the Artifact is created, are you saying I need to run a PowerShell script to actually deploy the database? If I can just get the deployment part to work, that will be most of the battle. Then I want to go back and add a bunch of testing in whenever a change is submitted in source control. Any additional help is GREATLY appreciated. / comments
I feel like I'm so close, but somehow I'm missing something. For example, do I need to download and install NuGet in order for Bamboo to create the NuGet artifact? Once the Artifact is created, a...
How to delpoy with Bamboo and DLM Automation
I cannot seem to find an easy way to deploy a build I created in Bamboo. First, I created a database build, using my local copy of the git RedGate code that is used to link up to my database for s...