Presented by Jochen Jonckheere and Pascal Mestdach

Abstract:

We will bring you the story of our journey into database change management. We share our experiences with concrete examples/common situations and explain the different parts of Database Change Management along the way. During our journey we encountered several problems. We let participants reflect on how they would solve these problems, before we show the solution we picked. This is an interactive technical session where you will see 2 developers working together, writing some small sql scripts, breaking and fixing automated builds and even in the end a tool for handling Database Change Management in an automated way in the .NET environment.

Format and length:

Experience report with interactive demonstration (90')

Intended audience and prerequisites:

Who will benefit from this session?

  • Developers involved in product development
  • Database Administrators
  • Technical Coaches who want to improve their application lifecycle management.
  • Operations who have to install the software and update the production database.

Do you expect them to have certain knowledge or experience?

  • We expect that the audience knows the concept of Version Control and Continuous Integration.

Objectives of the session:

What is the focus of this session?

  • We explain the need for having a system for automated database deployment and change management.
  • We cover topics from the book "Refactoring Databases" such as developer sandboxes, versioning you database, having migration scripts, deployment,...

What is the 'one' idea you want to get across?

  • Having a scripted database sandbox is a must, and having a reliable system which automates the database migrations makes life easy.

When will you consider the session be a success?

  • Participants will be able to explain what Database Change Management is in less than a minute.
  • Every participant takes at least 1 thing back home to improve the way they handle database changes in their environment.

Benefits, for the participants and the presenters:

for the participants:

  • lot's of learning, sharing experiences, seeing how we made our way to a system that is maintainable and scalable.
  • they will see parts were they recognize their situation, and will see things to take back home

for the presenters:

  • new insights on how other people solved the issues we had
  • sharing experiences