Migrations for people who love their databases.

steps

Build

Develop your database ‘Online’ using the tool of your choice
(eg. SSDT designers or SSMS)

Sync

Use the ReadyRoll tool-window within Visual Studio to preview & import changes into your project

Script

A numerically-ordered SQL script is added to your project which you can refine or rewrite as needed

Package

Check your project into Source Control and deploy your database with a CI server or Octopus

Develop and deploy SQL Server databases with T-SQL migrations. Integrates with SQL Server Data Tools (SSDT) for authoring and Octopus for deployment.

ReadyRoll works with Visual Studio 2010/2012 & supports SQL Server 2005+

Features

Develop with Ease

Development
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.

Collaborate Using Source Control

Source Control
All ReadyRoll project assets are stored as T-SQL and can be committed to your existing source control system (via a Visual Studio provider plugin, eg. TFS, VisualSVN, Git Extensions etc).

Easy Build Setup

Build
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.

Deploy with Octopus

Deploy with Octopus
ReadyRoll comes with Octopus Deploy support out-of-the-box, enabling consistent database deployments through your lifecycle environments (Test/Staging/Production).
NEW IN VERSION 1.5: Deployment previews

Roll It Your Way

Migrations
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.

Meet Our Fans

An awesome SQL database change management tool...[1]
This is what VS Database Edition should have been. [2]

- Paul Stovell (October 2012)


Hands down, ReadyRoll has had the easiest and most complete integration with our development workflow... I'd highly recommend giving this tooling a shot if you're working against SQL Server.[1]

- Nathan Donze (December 2012)


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.[1]

- Rob Sullivan (December 2012)


Seriously impressed with how easy it is to use @ReadyRollSQL for database deployment. #timetoputfeetup[1]

- Colin Byrne (May 2013)