Local Database - Code Aperture

Code Aperture

Sign in Subscribe

Local Database

A collection of 4 posts

Using SQL Source Control to Filter Out Unwanted Items

Using SQL Source Control to Filter Out Unwanted Items

Everything written on this site is how to get a database change automatically pushed up through the environments. But that was for the entire database. There are some parts of the database where they shouldn't be put under source control or shouldn't be promoted. Now you are probably thinking, "that

Branching with Redgate SQL Source Control

Branching with Redgate SQL Source Control

A couple of years ago my team and I decided to change the name of a column in a loan origination system. 99% of the time this was no big deal. However, this was the primary key identity column used to uniquely identify a loan in the application. Renaming a

Using Gitflow and Redgate DLM Automation for Continuous Delivery

One of the key reasons to use Redgate's Tooling is to deliver value faster to the business. In order to do that, it is important to have a branching policy in place. This is only possible with a local database and Redgate's tools. Prior to implementing their tools, all developers

Six Ways to Fail At Local Database Development

A while ago I was assigned to a project to move all of all the business logic from Oracle packages into C# code. Before I could even start moving the code I had to create a suite of tests covering those business rules in the database. The Oracle packages read