Building an automated development environment.

The project goal was to automate and maintain the building process of a development environment.

I faced the challenge that the development and test databases ran on linux operating system. I had to migrate this databases onto the notebooks of the sales and consultant colleagues and refresh them regularly. These notebooks ran Windows operating system. The database structure was poorly designed and because of this platform differencies the migration process had tons of problems each time.

I managed to overcome the problems by modifying the database structure and creating a new installation order of the application and altering the compilation order of the database schema objects. After this refinement the problems vanished during the database migration process. Furthermore I created a CI / CD pipeline in order to speed up the application deployment process. I also automated the database backup, restore and verify processes.

The client gained the following benefits. The building time of a new development environment was decreased from 1 day to 1 hour. The development process has been greatly accelerated. The clients of my client were more satisfied because they got the bug fixes faster and earlier.

The hidden or known issues I managed to solve in this project. The incompatibility problem between the two operating systems.