Schema changes can be initiated directly against your database: use SQL Server Data Tools to design your objects (available for both VS2010 & VS2012), or if you prefer, import changes as you go from SSMS.
All ReadyRoll project assets are stored as T-SQL and can be committed via existing source control provider (eg. TFS, VisualSVN, Git Extensions etc).
In addition to T-SQL script parsing, ReadyRoll uses gated deployment to validate object dependencies. ReadyRoll projects are based on MSBuild, so automating builds within your favourite Continuous Integration server is a cinch.
ReadyRoll comes with Octopus Deploy support out-of-the-box, but you can deploy ReadyRoll's SQLCMD packages using any 3rd party tool you like (eg. InRelease, Bamboo, uDeploy etc).
NEW IN VERSION 1.9: ReadyRoll can now deploy to Microsoft Azure SQL!
Migrations are first-class citizens of ReadyRoll projects, giving you precise control over how your database is deployed.
Use drift correction to track outside changes and keep your target environments in-sync.
WHAT PEOPLE ARE SAYING
“An awesome SQL database change management tool. This is what [SSDT] should have been.”
- Paul Stovell, creator of Octopus Deploy
“This product is fantastic. Saves us a lot of time and makes our release process consistent and repeatable.”
- John Adams, TrueBlue, Inc.
“Leave work, get home, clone project, [ReadyRoll] syncs and seeds my db with my branch... I keep on coding and don't miss a beat.”
- Rob Sullivan aka @datachomp
“Hands down, ReadyRoll has had the easiest and most complete integration with our development workflow.”
- Nathan Donze
“Seriously impressed with how easy it is to use @ReadyRollSQL for database deployment. #timetoputfeetup”
- Colin Byrne
“All developers become T-SQL script authors once you show them how easy it is to import table changes and even look-up data.”
Read more about how FlexiGroup uses ReadyRoll
- Damian Haynes