ReadyRoll Pro について

Visual Studioでマイグレーションスクリプトを利用したデータベースの開発とデプロイ

ReadyRoll brings Dev and Ops together, allowing users to develop and deploy SQL Server databases in Visual Studio with a migrations-based approach. 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.

Migrate through schema versions with ordered scripts in Visual Studio.

Users define incremental migration scripts for each database change during development. At release time, these scripts form the building blocks for a full deployment script.

Because users make changes to both the application and database in Visual Studio, they can check in combined changes to version control. This establishes a single source of truth for application and database.

ReadyRoll also brings the review of changes into development, so bugs are caught early when they’re still cheap to fix. Fixes are applied and tested while still in development.

Model-based deployments in Visual Studio SQL Server Data Tools (SSDT) usually involve generating a script at deployment time. Generally, this requires a pre-deployment approval step and often involves a dedicated DBA.

ReadyRoll moves this step into development, encouraging DBAs and developers to combine forces and work together on tested migration scripts early in the lifecycle.