1 / 6

Using the Database Migration Service of AWS

Get Enterprise-level Data Integration for Snowflake, S3, SQL Server, Redshift, Azure Synapse, and more. Lightning-fast data replication in real-time 24x7 in your data lake. For large enterprises, fast data ingestion in bulk with partitioning and multi-thread loading. Create real-time data lakes without any coding. <br>

troyevans275
Download Presentation

Using the Database Migration Service of AWS

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Using the Database Migration Service of AWS AWS DMS (Amazon Web Service Database Migration Service) is a service based in the cloud and facilitates quick and seamless migration of databases to AWS. Migration may be from on-premises servers to the cloud or from one cloud provider to another. The advantage here is that downtime is not required for the process as the source database remains always functional.

  2. AWS database migration service replicates data with high availability and it is possible to consolidate several databases into a single petabyte-sized data warehouse by streaming data to Amazon S3 or Amazon Redshift. If you are migrating databases to Amazon Dynamo DB, Amazon Aurora, or Amazon Redshift, you can avail free AWS database migration service for six months. There are two types of migration with the AWS database migration service.

  3. Homogeneous MigrationThis form of migration is done when the database engines, the data codes, data types, and the schema structures of the source and the target databases are the same. Due to this compatibility, migration is a one-step process. After a link is established between the source and the target databases, migration can be started with a click of a button. AWS DMS thereafter auto handles the full process. Examples of homogeneous migration are Microsoft SQL Server to Amazon RDS for SQL Server, MySQL to Amazon Aurora, Oracle to Amazon RDS for Oracle, or MySQL to Amazon RDS for MySQL.

  4. Heterogeneous MigrationThis method is carried out when the source and the target database engines and their data codes, data types, and schema structures are different. Here, unlike homogeneous migration, the process is a two-step one. First, with the AWS Schema Conversion Tool (AWS SCT), you have to convert data codes and schema structures of the source databases so that they match that of the target databases. Only after this can the migration be taken up. Instances of heterogeneous migration are Oracle to Amazon Aurora, Microsoft SQL Server to MySQL migrations, or Oracle to PostgreSQL.

  5. Organizations follow one of these two forms depending on their types of database engines and their attributes. • There are several benefits of the AWS database migration service.First, AWS DMS handles the complete infrastructure needed for migration automatically including deploying, tracking, and managing all activities. Once the AWS database migration service is configured, migration can be started in minutes.

  6. Next, being based in the cloud, the AWS database migration service offers unlimited storage facilities. It is also a very affordable option as users are charged only for the quantum of storage resources consumed and not any upfront fees. When there is a shortfall in storage during migration, additional space can be downloaded and migration can be resumed instantly. In contrast, traditional models charged flat fees and heavy maintenance costs. AWS database migration service provides users with all the advantages of a cloud environment like cost-efficiency, data security, and quick and seamless migration to the cloud.

More Related