Not using Visual Studio Enterprise 2017?
You can still try ReadyRoll Pro as part of the SQL Toolbelt.Try SQL Toolbelt for 14 days
“ReadyRoll is fantastic. Saves us a lot of time and makes our release process consistent and repeatable.”
ReadyRoll’s migrations-driven approach means you can be confident that database changes are developed and tested early in the lifecycle, added to version control and remain immutable from development all the way through to production.
Scripts get a sequential number, so you can be sure that what you deploy is exactly what you intended and in the correct order.
Without leaving Visual Studio, you can pick up and edit scripts from other team members, even if their database changes have been scripted in SSMS. The version control system you’re connected to via Visual Studio handles merging for you, and you can even kick off builds.
Integrate ReadyRoll with your continuous delivery pipeline. Trigger builds whenever you commit, and use the build artifacts to deploy changes to all your environments.
ReadyRoll also uses MSBuild and has an extension in the VS Marketplace to make setting up database builds and releases in VSTS/TFS easy. You can preview your database upgrade script and get a summary, and with ReadyRoll Pro get a diff report of database changes too.
Auto-generate SQL migration scripts with ReadyRoll to reduce time spent coding SQL by hand.
ReadyRoll’s migration scripts are generated by the SQL Compare engine, the industry standard for comparing SQL Server database schemas. Use the migrations scripts as they are, or edit them in Visual Studio before sharing them.
Verify your migration scripts with ReadyRoll before deploying your database changes to production.
ReadyRoll can test your script to identify SQL Server errors, such as missing dependencies or invalid code, before the script is deployed for real.
You can also use ReadyRoll Pro to manage schema drift and prevent unexpected deployment issues.
ReadyRoll Pro makes it easy for teams to work together on database changes.
The Offline Schema Model means you can access a read-only view of your database content at the object level. This makes it simple to perform audits of a team’s changes made over time.
The Programmable Objects feature also saves time when working with code-based objects, such as stored procedures, triggers or views. ReadyRoll Pro extracts these objects into re-runnable script files and adds them to source control. Multiple developers can then edit objects concurrently through branching and merging.
SSDT Database Projects takes a purely state-based approach to database deployment, in contrast to ReadyRoll Pro’s migrations-first approach. This makes SSDT Database Projects a useful solution for simple, infrequent database changes, but if you want to make regular database changes with the support for more complex schema changes, try ReadyRoll Pro. Find out why in ReadyRoll Pro’s FAQ.
“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.”
|Write a migration script for a database change|
|Auto-generate migration scripts – powered by SQL Compare|
|Customize auto-generated migration scripts|
|Verify migration scripts locally|
|Deploy database migrations during a VS build|
|Organize migrations for easier branching/merging and navigation (Semantic versioning)|
|Pre/post deployment scripts|
|Extensions for build and release tools including VSTS, TFS, and Octopus Deploy|
|Work quickly and efficiently with code-based objects e.g. stored procedures (Programmable Objects feature)|
|Offline Schema Model for object-level history|
|Include static data alongside schema changes|
|Customize schema and data comparison options|
|Customize schema comparison filters|
|Generate a diff report of database changes|
|Generate a schema drift report|
|Generate a schema drift correction script|
|Easy deployment of CLR database objects|
|Supported technologies||Core Edition||Pro|
|Visual Studio 2017 Enterprise edition|
|SQL Server 2016, 2014, 2012, 2008 R2, 2008, 2005|
|Azure SQL Database|
|Visual Studio 2015 – all editions|
|Technical Support||Core Edition||Pro|
|Community support via forums, documentation||Full Redgate support:
email, telephone, forums, documentation
If you’re looking to extend DevOps processes to your SQL Server databases and you’re not sure where to start, get in touch.
Redgate has specialized in database software for 17 years. Our products are used by 804,000 IT professionals, in more than 100,000 companies.
Redgate offers comprehensive documentation and a friendly, helpful support team. An average 87% of customers rate our support 'Excellent'.
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