Conversion mechanism for complex cohabitation databases

A computer program product for automating a software version downgrade of a database management system, the computer program product comprising a non-transitory computer-readable storage medium having computer-executable instructions to:

• receive a request from a user via a user device to launch a downgrade tool;
• transmit a request for authentication information from the user;
• perform a pre-validation check prior to performing a backup of a target device database comprising:
• verifying a password for the user and determine if the user is authorized to perform the downgrade on the target device;
• verifying drive mappings on the target device to determine a valid storage configuration on the target device;
• and
• performing a test of a remote connection between the user device and the target device;
• receive the authentication information from the user via the user device and authenticate the user to access the downgrade tool on the user device;
• generate a connection between the user device and a target device, wherein the target device hosts a database to be downgraded;
• generate the backup of the target device database and transmit the backup to the user device;
• receive information for the target device and the database and automatically detect a database version and a server version;
• based on the database version and server version detected, generate multiple server scripts for downgrade of the target device database;
• execute the generated server scripts to downgrade the target device database;
• execute a post-task operation, wherein the post-take operation comprises performing a restore operation and re-applying original settings of relational database components from a relational database server to update database operating system server registry settings;
• and
• generate a database discovery report, wherein the database discovery report comprises a complete edition and version of all relational database server components and services installed on the target device.

A computer implemented method for automating a software version downgrade of a database management system, the computer implemented method comprising:

• receiving a request from a user via a user device to launch a downgrade tool;
• transmitting a request for authentication information from the user;
• performing a pre-validation check prior to performing a backup of a target device database comprising:
• verifying a password for the user and determine if the user is authorized to perform the downgrade on the target device;
• verifying drive mappings on the target device to determine a valid storage configuration on the target device;
• and
• performing a test of a remote connection between the user device and the target device;
• receiving the authentication information from the user via the user device and authenticate the user to access the downgrade tool on the user device;
• generating a connection between the user device and a target device, wherein the target device hosts a database to be downgraded;
• generating the backup of the target device database and transmitting the backup to the user device;
• receiving information for the target device and the database and automatically detecting a database version and a server version;
• based on the database version and server version detected, generating multiple server scripts for downgrade of the target device database;
• executing the generated server scripts to downgrade the target device database;
• executing a post-task operation, wherein the post-take operation comprises performing a restore operation and re-applying original settings of relational database components from a relational database server to update database operating system server registry settings;
• and
• generating a database discovery report, wherein the database discovery report comprises a complete edition and version of all relational database server components and services installed on the target device.