It gives you a fast, reliable way to test and deploy your database changes and a single set of development techniques that cover application and database.
You can ship updates to your customers whenever you choose, and you get the review steps and drift monitoring you need to make sure your deployments are safe for production.
Take your next steps towards a truly agile Database Lifecycle Management process today, with a 28-day free trial.Download 28-day free trial
Speed up development, cut the risk of deployment problems, and take manual change management off your developers’ hands, with SQL CI.
Ship changes to your customers as soon as they’re ready, cut out human error at deployment, and help your operations team ensure changes are production-ready with built-in reviews, all from SQL Release.
Check your databases are in their expected state before you deploy, and catch ad hoc changes that could cause deployment failure, with DLM Dashboard.
SQL CI and SQL Release plug into the CI and release management tools you use for your application, so you can test and deploy your database too. You don’t have to change the way you work and you get more from your development infrastructure:
The DLM Automation Suite tests and deploys your database using the world’s most trusted technology for SQL Server database changes: the SQL Compare engine.
Add your database to your continuous integration process
Set up database CI with SQL CI, TFS Build, and SQL Source Control
Set up database CI with SQL CI, TeamCity, and SQL Source Control
Make fast, reviewable production deployments of database changes
Be the first to know when any of your database schemas change
Compare and synchronize SQL Server database schemas from the command line
Compare and synchronize SQL Server database contents from the command line
Generate realistic test data fast, based on column and table names, from the command line
Automatically generate database documentation from the command line
Package database updates as an .exe file, from the command line
“True one-click deployment!”
“With DLM Dashboard I can monitor the Dev server more closely, which means I discover databases being deployed onto the Dev box, rather than just being called when it breaks.”
The SQL Developer Suite includes SQL Source Control, a plugin that lets you use your source control system with your database. Database source control is the first step in managing your database lifecycle proactively.
The Suite also contains seven other tools that speed up development and help with manual change management. If you’re taking your first steps in Database Lifecycle Management, or want extra ways to help your development team work faster, the SQL Developer Suite is the best place to start.
Find out more on the SQL Developer Suite pages.
A nuts-and-bolts look at the advantages of continuous integration for databases, and how to include SQL Server databases in your build automation process using SQL CI.
Continuous delivery for databases brings speed, efficiency, and predictability to your release cycle, by automating database deployments across a pipeline. Setting-up version control, CI, and automated release management can provide you with a steadier stream of reliable releases.
In this practical demo, Alex Yates, Pre-Sales Engineer at Redgate, will show you how to set up continuous delivery for your SQL databases using TeamCity, Redgate tools, and Octopus Deploy. You’ll learn best practices for continuous integration, continuous delivery, and automated deployments to set up your own pipeline.
Dave and Annette talk about their development environment and how to use Redgate tools together with TeamCity continuous integration as an approach to running database projects.
Find out how Tissue Typing Systems came to trust their database deployments after switching to Redgate’s DLM tools.
The SQL Developer Suite is licensed per user. You can use the tools included in the Suite on any machine, so long as it’s just you as a single user working with these tools. If several people are using the SQL Developer Suite, you’ll need to purchase the appropriate number of user licenses.
The DLM Automation Suite is licensed per agent and intended for team use.
Typically this means a build or release agent such as TeamCity’s 'build agent' or Octopus Deploy’s 'tentacle'. In addition, this covers, for example, running the SQL Compare Pro command line from a scheduled task for use by a team.
You need one license per agent running Redgate automation tasks. If you have a single agent (e.g. TeamCity’s 'build agent' or Octopus Deploy’s 'tentacle') that handles Redgate automation tasks, you only need one license for this agent. If you have several agents, each running Redgate automation tasks, you need a license for each of these agents.
For example, if you are using SQL CI and SQL Release on the same agent, only one DLM Automation Suite license is required. If you are using SQL CI and SQL Release on two different agents, two licenses are required.
For your personal use, all you need is the SQL Developer Suite under its per user licensing. This is the case even if you’re using the SQL Compare command line on your desktop machine and, for example, a laptop.
If you’re using the command line for a team use case – most commonly this involves automation using a continuous integration or release management system – you need to use the DLM Automation Suite. The SQL Developer Suite is licensed per user whereas the DLM Automation Suite is licensed per agent. In addition to the difference in licensing, the DLM Automation Suite offers additional tools that simplify and enhance the Database Lifecycle Management process. These tools include DLM Dashboard, SQL CI, and SQL Release.
The SQL Developer and DLM Automation Suite are priced at $1,795 per unit – the former per user, the latter per agent.
Getting your database under version control is the first step in successful Database Lifecycle Management. The tools in the DLM Automation Suite work best with Redgate’s SQL Source Control, which is available as part of the SQL Developer Suite.
Tom, a SQL Server developer at Company X, regularly uses the command line in SQL Compare Pro for some basic compare and sync tasks that don’t involve a build server.
Tom’s team has also recently put a continuous delivery process in place, including both continuous integration and release management for the database. Redgate’s SQL CI executes an automated build and test process (using the SQL Compare command line) upon every check-in to SQL Source Control. SQL Release executes an automated deployment process using the NuGet package created by SQL CI.
Company X bought a 5-user SQL Developer Suite license for Tom and his team of four others, so they can take advantage of SQL Compare Pro for manual day-to-day compare and sync tasks, and SQL Source Control to get the database under version control. In addition, they purchased a 2-agent license for the DLM Automation Suite to run SQL CI on a TeamCity build agent and SQL Release on an Octopus Deploy tentacle (the release agent).