# US 11,308,050 B2 · Conversion mechanism for complex cohabitation databases > Agents: this data is available as JSON from the patentgrep API and MCP server — see https://patentgrep.com/llms.txt - Number: US 11,308,050 B2 - Document ID: US11308050B2 - Status: Granted - Kind: B2 - Application number: 16/685,562 - Filed: 2019-11-15 - Published: 2021-05-20 - Granted: 2022-04-19 - Earliest claimed: 2019-11-15 - Assignees: Bank of America Corporation - Applicants: Bank of America Corporation - Inventors: Joel Banaag Lim - Web page: https://patentgrep.com/patent/US11308050B2 ## CPC - G06F 16/217: {Database tuning (G06F16/2282 takes precedence; database performance monitoring G06F11/3409)} - G06F 11/1446: Point-in-time backing up or restoration of persistent data - G06F 11/1448: {Management of the data involved in backup or backup restore} - G06F 11/1451: {by selection of backup contents} - G06F 16/2329: {using versioning} - G06F 16/235: {Update request formulation} - G06F 16/284: {Relational databases} - H04L 63/083: {using passwords (cryptographic mechanisms or cryptographic arrangements for entity authentication using a predetermined code H04L9/3226)} - G06F 2201/80: Database-specific techniques - G06F: ELECTRIC DIGITAL DATA PROCESSING (computer systems based on specific computational models G06N) - H04L: TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION (arrangements common to telegraphic and telephonic communication H04M) ## Abstract Embodiments of the invention are directed to systems, methods, and computer program products for streamlining the processes involved with the cohabitation of relational database management system component versions. The system is further configured to automate the performance of edition downgrades of relational database management system services as well as automate edition downgrades for relational database management system server reporting services, server integration services, and server analysis services. Furthermore, the system is configured to launch command line interface on a user device, connect to target relational database components, retrieve necessary information, and automatically detect relational database management software versions. During the system processes, the system is designed to automatically performs pre-validation tasks and generate backup script files in chronological order. ## Claims ### Claim 1 A system for automating a software version downgrade of a database management system, the system comprising: at least one memory device with computer-readable program code stored thereon; at least one communication device; at least one processing device operatively coupled to the at least one memory device and the at least one communication device, wherein executing the computer-readable program code is configured to cause the at least one processing device 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. ### Claim 2 (depends on 1) The system of claim 1, wherein the user device is connected to the target device via a remote desktop portal. ### Claim 3 (depends on 1) The system of claim 1, wherein the multiple server scripts are stored on a desktop of the user device and the one or more server scripts are executed on the target device using a command line interface. ### Claim 4 (depends on 1) The system of claim 1, wherein the system is configured to transmit an option to the user device to generate an additional database discovery report for the target device without performing a database downgrade by using an ancillary downgrade tool. ### Claim 5 (depends on 1) The system of claim 1, wherein each of the multiple server scripts are executed one-by-one in a specific chronological order. ### Claim 6 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. ### Claim 7 (depends on 6) The computer program product of claim 6, wherein the user device is connected to the target device via a remote desktop portal. ### Claim 8 (depends on 6) The computer program product of claim 6, wherein the multiple server scripts are stored on a desktop of the user device and the one or more server scripts are executed on the target device using a command line interface. ### Claim 9 (depends on 6) The computer program product of claim 6, wherein the system is configured to transmit an option to the user device to generate an additional database discovery report for the target device without performing a database downgrade by using an ancillary downgrade tool. ### Claim 10 (depends on 6) The computer program product of claim 6, wherein each of the multiple server scripts are executed one-by-one in a specific chronological order. ### Claim 11 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. ### Claim 12 (depends on 11) The computer implemented method of claim 11, wherein the user device is connected to the target device via a remote desktop portal. ### Claim 13 (depends on 11) The computer implemented method of claim 11, wherein the multiple server scripts are stored on a desktop of the user device and the one or more server scripts are executed on the target device using a command line interface. ### Claim 14 (depends on 11) The computer implemented method of claim 11, wherein the system is configured to transmit an option to the user device to generate an additional database discovery report for the target device without performing a database downgrade by using an ancillary downgrade tool.