Amazon Technologies, Inc.

John MacDonald Winford

Ilia Gilderman

Jeremiah Wilton

Edward Paul Murray

Nicolas Anton Medhurst Hertl

Eran Schitzer

Rostislav Babocichin

Arun Kumar Thiagarajan

Chen Zhang

Grant Alexander Macdonald McAlister

Michael J Russo

Parker J Lord

Harpreet Kaur Chawla

Knievel Co

Danial George Neault

Sameer Malik

Satheesh Peringandookaran Subramanian

Samujjwal Roy

Venu Reddy

Michael D Soo

Siva Raghupathy

Gal Eliraz Levonai

Nathan McGuirt

John Calhoun

Benjamin Snively

Roy Edward Stephan

Alexey Gershun

Ramya Kaushik

Systems and methods are provided to enable a partial migration of applications from one database system to another without modifying the applications. In embodiments, a proxy server is configured to monitor the application's usage of a current database, and generate a migration plan to partially migrate database objects used by the application to a different type of database. An object may be selected for migration based on its usage level or its portability. After the partial migration, the proxy server may remain in place as a request router to route the application's requests to the two databases. In embodiments, the migration system may forward queries to both databases and compare the query results received from the two. Based on the comparison results, the migration system may programmatically determine adjustments to its query handling configuration settings.

Partial migration of applications across database systems

A workload of a database may be evaluated to provide a database migration recommendation. A request for a recommendation to migrate a database to a new host may be received. An evaluation of the workload of a client application of the database at a current host may be performed. The migration recommendation may be returned based on the evaluation of the workload of the client application of the database. In some embodiments, the migration recommendation may trigger an automated migration of the database to the new host.

Evaluating workload for database migration recommendations

A system such as a service of a computing resource service provider includes executable code that, if executed by one or more processors, causes the one or more processors to identify a set of resources associated with a first database system, determine, based at least in part on the set of resources, an expected outcome of an operation of a second database system, and generate, executable code that, if executed, verifies an actual outcome of the operation of the second database system against the expected outcome. The system may be utilized as part of a database migration process where data from a first database system is transferred to a second database system.

Database migration systems and methods

Data is migrated between a source database and a target database. The source database management system ('DBMS') remains operational during the migration. A user selects the source DBMS and target DBMS, provides connection information used to connect to the database management systems and selects a virtual machine instance to perform the migration in conjunction with a database migration service. After the setup is complete, the virtual machine instance in conjunction with the database migration service performs data type transformations, and other operations, without user intervention. The database migration service also converts, without user intervention, the source schema and code to a format compatible with the target DBMS. Any code that is not converted is marked to assist the user of the database migration service identify where manual re-coding is required. The database migration service can also provide recommendations as to a target DBMS that is a suitable target DBMS.

Migrating data between databases

Distributed extraction of data for migration may be implemented for migrating data sets from a first data store to a second data store. Assignments may be determined for different migration agents to obtain and store the data set in the second data store along with a format for storing the assigned data set portions. The migration agents may then be caused to obtain the assigned portions and store the assigned portions in the second data store according to the identified format. Further operations to request or direct the ingestion of the data set from the second data store may be performed by migration agents with respect to a third data store that performs data ingestion.

Distributed data set extraction for migration

A method and system for validating data migrated from a source database to a target database and storing validation metrics resulting from validating the data are described. The system receives validation information to be used to validate data to be migrated from a source database to a target database. The system validates the data using the validation information and stores validation metrics resulting from validating the data.

Data validation of data migrated from a source database to a target database

Validation of a migration task to migrate data from one data store to another may be performed prior to the migration of the data. Parameters associated with the migration may be evaluated according to one or more types of validations for the migration task. In some embodiments, users may specify the validations to perform for the migration task. A determination as to whether the migration task is valid may be performed for the migration task based on the parameter evaluations. A result indicating whether the migration task is valid may be provided to a user.

Migration task validation before data migration

Errors may be detected and mitigated during the migration of data. Migration of data from a source data store to a target data store may be monitored for errors. When an error is detected, one or more responsive actions may be identified to modify performance of the migration. In some embodiments, responsive actions may include further analyses to validate the migration. In some embodiments, the responsive actions may be corrective actions to correct the detected error. Once identified, the responsive actions may be performed to modify performance of the migration.

Error detection and mitigation during data migrations

Growing community of inventors

Vancouver, Canada

John MacDonald Winford