ReadyRoll

ReadyRoll

Solving Visual Studio database delivery problems with ReadyRoll

For .NET developers working with Visual Studio (VS), the introduction of Database Projects with SQL Server Data Tools (SSDT) brought to VS the ability to manage changes to the database schema and code objects, just like any other type of application code. An added advantage is that the declarative style of SSDT’s project files lends itself […] Read more

ReadyRoll

Deploying Entity Framework code first migrations with T-SQL

If you’ve reached the point where the DB change management approach of Code First migrations is no longer meeting your deployment needs, it might be time to consider moving to a change script-based approach. This week’s ReadyRoll release introduced a simple integration with Code First that allows you to continue modelling your database using Entity […] Read more

ReadyRoll

Transaction-handling techniques in T-SQL deployments

This question was recently posed by one of our customers: [crayon-5975d015c42f3441301713/] For the most part, we have resisted putting excess structure around the way that changes are deployed to your database. Unlike database projects that use the declarative-style of deployment, which work by synchronizing a source-controlled model of your schema to a target database, we […] Read more

ReadyRoll

Switching branches using drift correction

Last month I wrote about how drift correction can be used to keep track of changes that have been made outside of your established change management process. In that post I used the example of a DBA making a change directly to the Production environment. In this post we will look at how to re-sync […] Read more

ReadyRoll

Staying In-sync with drift correction

Getting everyone in a team behind a process change is hard. As a database developer, not only do you need to champion the new process within your own team, but you also need to extend the olive branch to your DBA to ensure everyone is on-board with the changes. This is where you may encounter […] Read more