Develop with Ease
ReadyRoll allows you to develop your database online: create and modify your schema directly within SQL Management Studio (or your favorite modeling tool).
You can also develop your database Offline, allowing you to search your schema and refactor objects within Visual Studio.
When you’re ready to synchronize your project with your database, use the ReadyRoll tool-window to preview pending changes and generate a deployment script in plain T-SQL.
Deploy with Confidence
ReadyRoll projects build a singular SQL batch script which can be deployed to all of your environments. This takes the guesswork out of how your Dev/Test/Prod databases will be affected during deployment.
Collaborate Using Source Control
With ReadyRoll, you can check all project assets -- including schema declarations and deployment scripts -- into source control using your current VCS provider in VS2010. This allows your team to
reproduce databases at any given point of time and isolate work-in-progress in a local ‘Sandbox’ environment. To make it easier to keep your local databases up-to-date,
ReadyRoll will let you know if there are pending deployment scripts to be executed within your project.
Build for Quality
Ensure that the integrity of your schema is maintained by utilising the quality tools built-in to Visual Studio: write unit tests for your database, perform static code analysis,
or check dependencies between schema objects. You can also add ReadyRoll projects to your MSBuild-compatible Continuous Integration server, allowing you to automate the build and
deployment of your database (NOTE: VS2010 is currently required on build agents).
Roll It Your Way
Unlock the refactoring potential of your database. Mix DDL (CREATE, ALTER, DROP) and DML (SELECT, UPDATE, INSERT) statements within your T-SQL deployment scripts: add a not-null
column to a table and populate it with a value from another table, or perform a bulk data update that employs a newly-created function. This provides you with fine-grain control
over how your database evolves.