The application relates to a
database automatic construction and deployment
change management method, which comprises the following steps: S1, a user designs a
database table structure through a
data modeling tool, and each
system always maintains a table structure baseline of the latest production online in the
data modeling tool; S2, a code warehouse carries out format checking on
database change information submitted by the user, and submits the database change information to the code warehouse after the format checking; S3, according to a code warehouse
directory structure and pipeline parameters configured by the user, database scripts are constructed and packaged, and the database DDL scripts are checked in the packaging process to verify whether the DDL scripts are all submitted through the
data modeling tool; S4, review of the change
SQL, scanning of a constructed release
package, identification of high-risk
sentence operations, manual confirmation and subsequent operation; and S5, dispatching of executed
SQL sentences. Compared with the prior art, the application can realize automatic management and control of
SQL scripts and online product packages and function requirement tracing.