The invention provides a
database adaptive migration method and
system based on a credential environment, and relates to the technical field of
data processing.The method comprises the steps that an intelligent migration model is used for analyzing the structure, including a table structure, index configuration, constraint conditions and data types, of a source
database, data size distribution is calculated, and a source
database structure feature result is generated; according to a source
database structure feature result, automatically selecting and configuring a
target database type, adjusting environment parameters of a
target database, and generating
target database configuration information; according to the structure of a source database and configuration information of a target database, a
data mapping rule is automatically established by utilizing an intelligent migration model, and the
data mapping rule comprises automatic correspondence of table names and field names, automatic conversion of data types, and an automatic migration scheme of indexes and constraints. According to the method, automatic and intelligent migration from the source database to the target database is realized through the intelligent migration model, the performance is automatically optimized, the migration report is generated, and the migration efficiency and quality are improved.