Upgrading and migrating a database by a migration tool

A computer program product for managing an in-place database migration upgrade, the computer program product comprising computer readable instructions embodied on tangible, non-transitory media that are executable to perform operations comprising:

• configuring a target database on a computing appliance that is communicably coupled with a distributed computing environment that comprises a source database, the source database comprising a plurality of productive database tables and a plurality of non-productive database tables;
• determining a distribution of database tables to migrate to the target database, the distribution comprising at least a portion of the plurality of productive and non-productive database tables from the source database and at least one new database table of a database upgrade;
• providing one or more configurations of a shadow database that comprises one of a fixed database or a clone of the source database;
• calculating a plurality of SQL statements that identify an adjustment of the portion of the plurality of productive and non-productive database tables;
• implementing the calculation of the plurality of SQL statements in the source database for execution in the target database;
• based on the implementation, performing:
• i) an uptime migration of the plurality of non-productive database tables and the at least one new database table to the target database, wherein the uptime migration comprises copying at least a portion of the shadow database to the target database based on the shadow database comprising one of a fixed database or a clone of the source database, and
• ii) a downtime migration of the plurality of productive database tables to the target database,
• wherein the uptime and the downtime migration is performed external to both the source database and the target database;
• and
• pointing a productive system of the distributed computing environment to the target database.

A system of one or more computers configured to perform operations comprising:

• configuring a target database on a computing appliance that is communicably coupled with a distributed computing environment that comprises a source database, the source database comprising a plurality of productive database tables and a plurality of non-productive database tables;
• determining a distribution of database tables to migrate to the target database, the distribution comprising at least a portion of the plurality of productive and non-productive database tables from the source database and at least one new database table of a database upgrade;
• providing one or more configurations of a shadow database that comprises one of a fixed database or a clone of the source database;
• calculating a plurality of SQL statements that identify an adjustment of the portion of the plurality of productive and non-productive database tables;
• implementing the calculation of the plurality of SQL statements in the source database for execution in the target database;
• based on the implementation, performing:
• i) an uptime migration of the plurality of non-productive database tables and the at least one new database table to the target database, wherein the uptime migration comprises copying at least a portion of the shadow database to the target database based on the shadow database comprising one of a fixed database or a clone of the source database, and
• ii) a downtime migration of the plurality of productive database tables to the target database,
• wherein the uptime and the downtime migration is performed external to both the source database and the target database;
• and
• pointing a productive system of the distributed computing environment to the target database.