My second presentation at Porto.Data (April 20) was about the two approaches, migrations and state, for database source control. During the presentation I explored the advantages and disadvantages of each approach. For migrations approach I used the tool Flyway and for state approach I used Redgate SQL Source Control. Besides presenting the pros and cons of each approach my goal was also to show that two approaches can be needed in different parts of the system, or at different times …
Blog Posts
Flyway is a open source database migration tool that allows you to manage database changes using migrations. Last week the version 4.0.1 has been released and I decided to write my first post about Flyway. I started to use Flyway command-line almost 3 years ago (version 2.2.1) and the main reason that took me to use and keep using nowadays is: it’s simplicity, “database migrations made easy”. This key factor is translated into the following: Zero dependencies (you need java and …
In February I made a new friend, I have joined the 2016 Friends of Redgate (FoRG) Program. I found Redgate and his products when I started working as DBA with special focus on database development and database changes delivery. SQL Source Control and DLM Automation Suite are great products for this purpose. However, what really impressed me were Redgate’s people: always ready to give you support, always ready to listen your feedback. As a Friend of Redgate I have the opportunity …
SQLSaturday #485 Lisbon 2016, held on February 20, was my third SQLSaturday event and my first as speaker. When I received the email saying that my session had been accepted in schedule’s event I felt happy and honored. My session, Road to database automation, was accepted as lightning talk. So I had 10 minutes to address the first stage of the database automation: database source control and it´s benefits. During that time I presented the reasons that lead me to …
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 …
The first question I thought was: if applications development includes “by default” concepts as source control, continuous integration and continuous delivery, why not database development? As Len Bass said in a conference: “A script is just a program”. All database changes can be scripted, so what is so special about databases? The answer is simple: data, specifically data persistence. One of my favorite answers was given by Grant Fritchey: “Deploying databases has the inherent problem of retaining the data after the …
Last Tuesday (15 December 2015) I made my first presentation in Porto.Data community. “Road to database automation” was the title and the this session had two main goals: discuss the challenges of database inclusion in the Application Lifecycle Management (ALM) and present a set of strategies and tools to achieve this inclusion. The effort of database inclusion in the “agile context” is designated as Database Lifecycle Management (DLM) and is composed by 3 main parts: database source control, database continuous …
One of my first projects using Arduino happened during the Christmas season, so seemed a good idea to create Christmas lights to illuminate and brighten the house. The first step is to gather the necessary hardware: 1 x Arduino, I used the Arduino 2009; 2 x breadboard, should be enough to perform the tests; 1 x switch button, it will be used to switch between the diferrent lightning effects; 8 x red LEDs 8 x green LEDs 8 x yellow …
My first contact with SQLSaturday event occurred in 2014 on the SQLSaturday#341 Porto 2014 edition as simple and curious attendant. A full day of learning, sharing and meeting people sounds to good to be true especially if it´s free. At the end of the day I was amazed, and asked myself why organize and event like this? The answer is quite simple: sharing. The same principle lead me to join Porto.Data community. It was here that I met Ivan Campos the …