Tag: SQL Change Automation

  • #ReadyRoll at #SQLintheCity

    When Redgate purchased ReadyRoll a few years ago, I wasn’t sure this was a great idea. After all, SQL Source Control and DLM Automation work really well to bundle up changes in a VCS and easily deploy them.

    However, as I worked with Daniel Nolan, the creator, and learned more about the tool, the more I liked it. After all, I’ve worked for a number of companies that used a migration strategy to make changes to our applications. I also like Visual Studio, so this was a great fit for me.

    At SQL in the City streamed last year, I presented a short talk on using ReadyRoll to deploy changes. I’ll write more about individual parts of this in 2017, but take a look at this video and see if ReadyRoll works for you.

  • Using ReadyRoll to Automate Database Migrations

    I like ReadyRoll, and this week at SQL in the City 2017, I get to show some of the product off. I’ll be doing mostly demos and coding, live, with ReadyRoll, sending my code through from development to QA to production.

    Despite the power and ease with which I use SQL Compare, SQL Source Control and the DLM Automation tools, I really like the ReadyRoll paradigm. It’s not better or worse, but it’s a method I’ve been more comfortable using to deploy code to databases. It’s the type of process I’ve had to manually build in the past, but now it’s much easier with the ReadyRoll project and plugin for Visual Studio.

    Join me and see how I use ReadyRoll to write code, track it, and then deploy it to various other environments.

    We’re broadcasting a virtual SQL in the City this year, on December 14/15. The same content is both days, spread out to cover different time zones on each day. I hope you’ll join us and see what Redgate has in store for 2017.

  • Getting Team City working with BitBucket

    As a part of building a CI/CD home lab, I set up TeamCity in the past. I plan on using this for multiple projects, and in fact, I’d built a basic Hello, World C# application as my first build.

    Now it is time to work on something more complex. As a part of my SQL Server Builds project, I decided to host the Ready Roll build here. That means connecting TeamCity to BitBucket.

    I had no idea how this might work, and some searching showed that this needed a plugin prior to v10, but the capability was built-in after that. I’ve been meaning to upgrade, so I did that first. As you can see, I have my TC v10 system, and when I go to create a new project, BitBucket is a first class citizen.

    2016-11-15 11_57_33-Projects — TeamCity

    Once I picked this, the system has me authenticate with Bitbucket (I won’t show this) and then get a key and secret that I paste into the dialog. This is fairly easy to follow, but for security purposes I’ll skip that. Once I’m authenticated, I can see my repos:

    2016-11-15 14_21_23-Create Project From Bitbucket Cloud — TeamCity

    I pick this repo and a project is created. In fact, TeamCity detects that I’ve got a VS solution in the repo, so it sets that as my build config.

    2016-11-15 12_02_58-Build Configuration — TeamCity

    That’s pretty cool, and I’m hooked up. Or am I? Let’s see. I’ll manually run a build.

    2016-11-15 12_43_56-Sqlserverbuilds RR __ Build _ #1 (15 Nov 16 12_36) _ Overview — TeamCity

    It doesn’t work. However, if you read the error, you’ll realize that the ReadyRoll project type doesn’t seem to work. That’s because I’m building on this server, which is separate from my development machine. I need to install the ReadyRoll binaries there.

    A quick download from Redgate, and I install ReadyRoll. Now when I click “run”, I get this:

    2016-11-15 12_44_05-Sqlserverbuilds RR __ Build _ Overview — TeamCity

    Success.

    There’s more to getting setup, but this is a quick look at getting TeamCity hooked up to BitBucket.

    If you want to try ReadyRoll, grab an eval.

  • ReadyRoll and Octopus Deploy Webinar

    I’ll be hosting a webinar next week, Thursday, July 28, with Daniel Nolan (t) (founder of ReadyRoll and fellow Redgate employee) and Damian Brady (b | t) of Octopus Deploy.

    We’ll be talking deployment, with demos to show you how to work with ReadyRoll for your deployment and then how to build a package to be automatically deployed though Octopus Deploy. Both are great products that I enjoy working with.

    Register today if you’re interested in seeing how migration based development and deployment works with ReadyRoll and Octopus Deploy.