Develop and deploy databases in Visual Studio with migration scripts
Want to work on databases in Visual Studio alongside your application? Feeling the pain of managing and deploying database changes manually? Then ReadyRoll Pro is the tool for you.
It generates numerically ordered SQL migration scripts that sit inside your project and take your schema from one version to the next.
You can add them to version control, use them to build and release, and automate database and application deployments, all in one process.
Deploying and developing databases with ReadyRoll Pro – a 2 minute intro
Download the SQL Toolbelt
Industry-standard products that make you productive, your team agile and your data safe
Save time with ReadyRoll Pro's automatic suggestions for migration scripts. You can use them as they are, or edit them in Visual Studio before sharing them with your team.
The scripts are generated by the SQL Compare engine, the industry standard for comparing and deploying SQL Server database schemas quickly and accurately.
Because you define your migration scripts up front, you keep precise control over how your changes are deployed.
Scripts get a sequential number, and you add them to your version control system as part of your complete solution in Visual Studio.
Change management is simple and there’s no chance of errors from running scripts in the wrong order.
Test scripts before they hit production with ReadyRoll Pro's shadow database.
Use this disposable clone of your database to test your deployment and check your scripts take you to the state you want.
When you’re ready to deploy for real, you can be certain your changes work.
ReadyRoll adds a new project type to Visual Studio. Your database changes live in the same solution as your application code.
Without leaving Visual Studio, you can pick up and edit scripts from other team members.
The version control system you’re connected to via Visual Studio handles merging for you, and you can even kick off builds.
Trigger builds whenever you commit, and use the build artifacts to deploy changes to all your environments.
ReadyRoll Pro also comes with built-in support for Octopus Deploy’s OctoPack. You can use Octopus variables in your scripts to configure how you deploy your changes to each environment.
Enable Programmable Objects in your project to source control stored procedures, triggers, views, and functions as individual T-SQL files.
This means when you and your colleagues make changes to these files, your usual version control system conflict resolution process applies.
When a developer attempts to check in changes, they’ll always be prompted to incorporate other changes first, rather than overwriting them.
ReadyRoll Pro brings Dev and Ops together. It moves the review of changes into development, so bugs are caught early.
Developers and DBAs can join forces to apply and test fixes early on, when it's still cheap.
— Brent Robinson, Release Management Team Lead, FlexiGroup
See how the Release Management Team at financial services company FlexiGroup has transformed the way they release databases.
Redgate's David Simner, Jon Hickford and Microsoft MVP Steve Jones present 10 tips and tricks for database migrations using ReadyRoll Pro and Visual Studio Team Services.
Check out the Frequently Asked Questions (FAQ) on ReadyRoll Pro for answers to a range of common questions.
How does ReadyRoll Pro compare to DbUp, Liquibase, SSDT or Entity Framework? Which environment strategy works best with ReadyRoll Pro? And does ReadyRoll Pro work with existing databases?
Read the ReadyRoll Pro team’s responses on these questions and more.
Develop your database in Visual Studio or SQL Server Management Studio.
Use the ReadyRoll Pro tool window in Visual Studio to preview and import schema and data changes.
This adds a numbered SQL script to your project, which you can edit if you need.
Check your project and scripts into source control, and deploy to your Dev/Test/Prod environments.
“You have an amazing product. I've been doing SQL change management in various ways for 15 years, and this is the first time it has actually been pain free.”
“ReadyRoll Pro has been pivotal to the success of our project. There’s really nothing that comes close to what ReadyRoll Pro can do for big teams.
Its seamless integration with Octopus has made our project very adaptable to change and providing a standardised process for version control with databases.”
“An awesome SQL database change management tool.”
“All developers become T-SQL script authors once you show them how easy it is to import table changes and even look-up data.”
“Leave work, get home, clone project, [ReadyRoll Pro] syncs and seeds my db with my branch... I keep on coding and don't miss a beat.”
“This product is fantastic. Saves us a lot of time and makes our release process consistent and repeatable.”
“Hands down, ReadyRoll Pro has had the easiest and most complete integration with our development workflow.”
“Seriously impressed with how easy it is to used @ReadyRoll ProSQL for database development. #timetoputfeetup”
“We like the granular control over releases that the migrations approach with ReadyRoll Pro gives us.”
This short video tutorial shows you how to start developing and deploying your databases with ReadyRoll Pro SQL projects for Visual Studio, including:
Redgate’s Database DevOps solution lets you extend your DevOps practices to SQL Server databases so that you can optimize productivity, agility and performance across the full database lifecycle and become a truly high performing IT organization.
From safely making a change in development through to monitoring its impact in production, Redgate is with you every step of the way. We give you the tools and insight you need to optimize your development processes, so you can keep your team moving, keep adding value and keep your data safe.
Learn more about the benefits
