Database DevOps & DLM - Redgate Software

Posts Categorized in Database DevOps & DLM

This is the most exciting time there’s ever been to be in the software space in general and the database world specifically. Continuous delivery practices have moved into the enterprise and the database needs to keep up too. At Redgate, we’re making it possible with a Database Lifecycle Management (DLM) process that mirrors the more familiar Application Lifecycle Management (ALM). The result? DevOps for the database becomes a reality. Crucially, Redgate software allies it to application DevOps by plugging into the same software stack. Find out more by reading our latest blog posts.

How Redgate helped define a truly automated database deployment process

At the end of 2016, we interviewed Bob Walker, a Lead Application Developer, to find out how he went about setting up automated database deployments using Redgate tools and what lessons he’d learned. The highlights make interesting reading. You describe the time before Redgate database automation as ‘truly the Wild West of database development’.... read more

Why people flocked to the SQL Clone live stream event

Live streaming events is something that’s rather new to Redgate, the first one being SQL in the City back in December, which was a great success. So with the launch of our new tool SQL Clone looming, we thought we’d do it again. There’s good reason too. While meeting people face-to-face at events is... read more

Why is my clone so small?

If you have a very large database, up to 2TB in size, SQL Clone will let you copy, or ‘clone’, that database many times, very quickly, making the full database available in multiple SQL Server instances across your development and test environments. And yet in each of these instances, the cloned database takes up... read more

Backup and restore of a SQL Clone

With SQL Clone, I can create multiple copies of my database, for testing, very quickly. First, I create an image of the source database, and then from that image I can create multiple clones. Each copy, or clone, appears to SQL Server as a normal database, and yet occupies a fraction of the disk... read more

Announcing Redgate Data Tools in Visual Studio 2017

Visual Studio 2017 is released today, and its new features like Live Unit Testing and configurable code style rules have already been grabbing the headlines. But inside the Visual Studio 2017 installer, another big surprise awaits: Redgate Data Tools. We’ve partnered with Microsoft so Visual Studio Enterprise subscribers can install ReadyRoll Core, SQL Prompt... read more

Database provisioning from backups using SQL Clone

In a previous article, Getting started with SQL Clone, I described how SQL Clone could remove much of the administrative burden from the database provisioning process, the advantages of a new, lightweight process to spin up “real databases” for use in development and test work, and finally how to produce data images and then... read more

SQL Clone: the aspirin for your database provisioning headaches

When developing a database as a team, most team members would generally prefer to work with their own, isolated copy of the database, rather than work on a shared development database. Up to now, however, there have been a number of additional management and security problems with the dedicated database approach and these burdens... read more

Team-based database development with SQL Clone

For most development teams, the database provisioning process involves some element of compromise. Often, developers will work with the up-to-date database schema but only a small sample of test data, for example. It’s a fast, lightweight approach that is sufficient for most simple tests, but it doesn’t necessarily reveal exactly how the application will... read more