All geek questions in one place

Tools and processes for managing application configuration

My question is related to best practices and tools used to promote application configuration data to a new environment as part of a typical testing cycle. The latter includes three environments: TEST, STAGING, and PROD. Code and configuration changes are applied first for testing, and then for switching to STAGING and then to PROD as soon as the tests pass at each step of the path.

Advancing software assembly from environment to environment is simple. However, managing the progress of the corresponding settings / data configuration changes is more complicated. The application is highly customizable, and the configuration data is large - a few GB stored in several hundred Oracle db tables.

Conceptually, the problem consists of:

  • Tracking all creates, updates, and deletes configuration data made in the application.
  • Transferring these changes from one environment to another

Due to the large number of manual changes, a lot of time and the likelihood of errors are required. My question is: are there any useful tools and strategies that can be used to automate / etch this process?

+3
source share
1 answer

Have you considered Oracle Auditing?

Set the audit in your configuration tables, then write a script that will read the audit data and build an SQL script that can be used to make the same changes in other databases.

+1
source

Source: https://habr.com/ru/post/1753909/

More articles:


All Articles