Posts Tagged with 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... read more

Octopus Deploy and ReadyRoll in under 5 minutes

When it comes to deploying SQL Server databases, Octopus Deploy and ReadyRoll make a great team. And with our new plugin you can get set up in record time! You can use Octopus Deploy Step Templates to provide a user interface for common tasks. We’ve created a ReadyRoll step template you can drop into... read more

Improving ReadyRoll performance, one line at a time

In our latest release, we sped up ReadyRoll’s performance more than x10 on large databases in two key areas of the product: script generation and project packaging. If you are new to a codebase and haven’t done any performance work on the application before, it is a good idea to get a big, bad... read more

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... read more

Why our customers are ready for ReadyRoll

We’ve just finished the acquisition of ReadyRoll, a database migrations and deployment tool that makes it easy for software teams to develop SQL Server databases within Visual Studio. That’s the headline news, but why did we do it, and are our customers really ready for it? I’ll answer the second question first. Yes. With... read more

How FlexiGroup uses ReadyRoll

FlexiGroup is a diversified financial services group providing point of sale interest free, no interest ever, leasing, vendor programs, interest free cards and other payment solutions to consumers and businesses. We talk to Damian Haynes, Senior Application Developer at FlexiGroup, about why his team selected ReadyRoll as their database change management tool. How did... read more

Transaction-handling techniques in T-SQL deployments

This question was recently posed by one of our customers: [crayon-594fbfa87e7d9129904834/] 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,... read more

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... read more