System and method for migrating databases

A computer-implemented method for optimizing migration of a database from a source system to a target system, comprising:

• collecting source parameters related to performance characteristics for the database on the source system;
• generating database configuration information on the basis of the collected source parameters and target parameters of the target system, wherein the target parameters will affect the operation of the database on the target system as compared to the operation of the database on the source system;
• and wherein the database configuration information is applicable to tune the database to operate on the target system;
• wherein the source parameters include plan cache data of the source system, the plan cache data indicating access plans for queries that were previously executed against the database on the source system;
• wherein generating the database configuration information comprises executing predefined rules on the collected source parameters, each rule defining a relationship between a collected source parameter and an action to be performed with respect to a corresponding target parameter to configure the database on the target system, wherein executing the predefined rules comprises comparing the collected source parameters with the target parameters and, for each comparison, determining a respective action to be performed to tune the database on the target system;
• installing the database on the target system;
• and
• configuring the database to run on the target system according to the database configuration information;
• wherein configuring the database comprises:
• (i) restoring the collected source parameters, including the access plans, on the target system;
• and (ii) tuning the database on the target system on the basis of the restored collected source parameters;
• wherein tuning the database comprises:
• optimizing the restored access plans for the target system based on a determined action of the database configuration information.