This was the first SQLPort event held in Aveiro. I was invited by Niko Neugebauer to deliver a session and I chose to explore the topic migrations-based approach vs state-based approach for database source control. The purpose of my talk was to let audience know about the two existing approaches to start with source control at database level. After presenting the advantages and disadvantages of each approach I promoted a discussion with the participants so they could understand how, where …
Tag: Database
In this post I describe some decision that you need to make when putting your database development under source control. “Commit a SQL script to a local repository and the push to a central repository” sounds easy. In fact the all process should be easy. The SQL script is the fundamental resource of the database source control process. The script can represent two perspectives: The desired definition of the database object (table, view, stored procedure, function…), a.k.a state-based approach; The desired …
Nowadays the question “Why put database under source control?” no longer makes sense. Probably “How to put database under source control?” is now the correct question. But before answering the second question let me answer the first identifying the reasons that led me/us team to invest on database source control: Is the first step of database automation In other words, if you want to assemble a database deployment pipeline you should put your database changes into a source control system; Keep …