ReadyRoll Pro(英語版)
Visual Studioでマイグレーションスクリプトを利用したデータベースの開発とデプロイ
Redgate Software 社の製品
2005 年より日本国内にてComponentSourceで販売中。
Save time with ReadyRoll’s automatic suggestions for migration scripts. You can use them as they are, or edit them in Visual Studio before sharing them with your team.
The scripts are generated by the SQL Compare engine, the industry standard for comparing and deploying SQL Server database schemas quickly and accurately.
Because you define your migration scripts up front, you keep precise control over how your changes are deployed. Scripts get a sequential number, and you add them to your version control system as part of your complete solution in Visual Studio.
Change management is simple and there’s no chance of errors from running scripts in the wrong order.
Test scripts before they hit production with ReadyRoll’s shadow database. Use this disposable clone of your database to test your deployment and check your scripts take you to the state you want.
When you’re ready to deploy for real, you can be certain your changes work.
ReadyRoll adds a new project type to Visual Studio. Your database changes live in the same solution as your application code.
Without leaving Visual Studio, you can pick up and edit scripts from other team members. The version control system you’re connected to via Visual Studio handles merging for you, and you can even kick off builds.
Trigger builds whenever you commit, and use the build artifacts to deploy changes to all your environments.
ReadyRoll also comes with built-in support for Octopus Deploy’s OctoPack. You can use Octopus variables in your scripts to configure how you deploy your changes to each environment.
Enable Programmable Objects in your project to source control stored procedures, triggers, views, and functions as individual T-SQL files.
This means when you and your colleagues make changes to these files, your usual version control system conflict resolution process applies. When a developer attempts to check in changes, they’ll always be prompted to incorporate other changes first, rather than overwriting them.
ReadyRoll brings Dev and Ops together. It moves the review of changes into development, so bugs are caught early.
Developers and DBAs can join forces to apply and test fixes early on, when it’s still cheap.