Azure SQL Database Content Synchronisation to Downstream Environments

Data Flow ====> Production –> Staging –> Integration –> Test –> Dev I have been working with various clients with different kind of requirements for each one of them. Thinking about it all of them lead to one common purpose. What is that? We develop applications and write automated tests to validate them on regular… Read More Azure SQL Database Content Synchronisation to Downstream Environments

DBA’s and Developers in Database Continuous Delivery Pipeline (Tools: Redgate Tools, Git, TeamCity and Octopus Deploy)

In past few months I have been involved with various clients in enabling Continuous integration and Continuous delivery process within the enterprise organizations. When speaking about databases as part of this process there is lot of noise within the room as if this is a scariest part of the world. This is not a surprise… Read More DBA’s and Developers in Database Continuous Delivery Pipeline (Tools: Redgate Tools, Git, TeamCity and Octopus Deploy)

Part 5: Continuous Delivery of SQL Server database by Source controlling in Git (Using Red-gate Tools, TeamCity and OctopusDeploy)

Most of the time in many organisation people are involved in shipping the code faster into various environments like Test, UAT, Staging and Production. After a while many hit the point of bottle neck in deploying the database changes where you cannot delivery continuously. I have been looking for a good product which can enable… Read More Part 5: Continuous Delivery of SQL Server database by Source controlling in Git (Using Red-gate Tools, TeamCity and OctopusDeploy)