{"id":81065,"date":"2022-01-24T04:22:43","date_gmt":"2022-01-24T09:52:43","guid":{"rendered":"https:\/\/www.whizlabs.com\/blog\/?p=81065"},"modified":"2024-04-30T16:07:17","modified_gmt":"2024-04-30T10:37:17","slug":"database-migration-with-aws-dms","status":"publish","type":"post","link":"https:\/\/www.whizlabs.com\/blog\/database-migration-with-aws-dms\/","title":{"rendered":"Database Migration With AWS DMS &#8211; Whizlabs Webinar"},"content":{"rendered":"<p><b>AWS <\/b><span style=\"font-weight: 400;\"><strong>Database Migration Service (DMS)<\/strong> allows the migration of databases to AWS in a secure way. It also supports homogeneous migrations, for instance, Oracle to Oracle, along with heterogeneous migrations, i.e. between different database platforms like Oracle to Amazon Aurora.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">To date, over 5,50,000 databases have been migrated using the AWS DMS.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Whizlabs conducted an elaborative webinar on \u2018AWS Database Migrations with DMS\u2019, with Mr. Brian H. Hough on 8th January, 2022. We have published a course about <a href=\"https:\/\/www.whizlabs.com\/aws-database-migration-services-dms\/\">AWS DMS<\/a>.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">The agenda of the Webinar was to learn:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><strong>SQL<\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong>AWS Serverless Database Ecosystem<\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong>RDS<\/strong><\/li>\n<li style=\"font-weight: 400;\"><strong>AWS DMS<\/strong><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\"><strong>Brian H. Hough<\/strong> is a certified blockchain and cloud developer, AWS Community Builder, and passionate advocate for innovation. He got his start in tech as the Chief Communications Officer for 8 Decimal Capital, a $60M global blockchain VC fund, while he worked as the Google Arts &amp; Culture Project Coordinator at the Harvard Kennedy School&#8217;s Project on American Indian Economic Development. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">He<\/span><span style=\"font-weight: 400;\"> is a Web2 and Web3 Developer, and the CTO and co-founder of AirBlock Technologies that is digitising supply chain and aerospace. He also runs the TechStack Playbook Podcast whose overall goal is to make App Software and tech fun and accessible bringing more inclusion to the tech community globally. He has been through multiple Hackathons, and <\/span><span style=\"font-weight: 400;\">won the ETHOnline &#8217;21 hackathon by building HelpMeDev.io, a decentralised founder-entrepreneur marketplace.<\/span><\/p>\n<h2>What is SQL?<\/h2>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-81078 size-full\" title=\"What is SQL\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql.png\" alt=\"What is SQL\" width=\"817\" height=\"456\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql.png 817w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql-300x167.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql-768x429.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql-753x420.png 753w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql-640x357.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/what-is-sql-681x380.png 681w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">SQL stands for Structured Query Language, made up of tables that are structured with fixed rows and columns, wherein you have a primary key for a primary table.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">For instance, we are tracking a library wherein there are multiple readers who are reading books. The two databases are readers and books. And there exists an ID1, that is Joe, and another ID that is Sally. In the books, we may have one book whose name is Star and another book called Journey, and we want to track all the different readers, the different books, and who is reading what. <\/span><\/p>\n<p><span style=\"font-weight: 400;\">So, under the joining table, this is basically mapping the relationship between the two tables, wherein you might have Sally who has Book1, and Joe with Book2. Here comes SQL into play because it helps you sort the fixed excel spreadsheets like tables to help you map and track your data.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">If we go on expanding the whole concept of database, there are multiple databases available other than SQL, for example:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">DynamoDB, a noSQL Database, that works based on the key-value pairs, which is exactly opposite of SQL<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Elasticache, an In-memory data stores with caching, graph database, such as how social media accounts are tracking relationships more closely<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Neptune, a fully-managed graph database service<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">MongoDB, a document-oriented database program<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">DocumentDB, a non-relational document database<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">QLDB, for having a fully immutable Quantum Ledger Database<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Blockchain, a decentralised type of database, specifically focussing on Ethereum for making nodes and then hyperledger for a private provisioned blockchain network<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Redshift, a relational database management service for analytics<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Keyspaces, which leverages Apache Cassandra for a database optimised for that kind of database.<\/span><\/li>\n<\/ul>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-81079 size-full\" title=\"The list of serverless databases in aws\" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws.png\" alt=\"The list of serverless databases in aws\" width=\"817\" height=\"458\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws.png 817w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws-300x168.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws-768x431.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws-749x420.png 749w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws-640x359.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/types-of-serverless-databases-in-aws-681x382.png 681w\" sizes=\"(max-width: 817px) 100vw, 817px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">This webinar was focused on RDS, the relational database service, which helps you with various services like Patching and Updating, done by the database management system.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">AWS has extracted that work out of the overall flow, allowing the user to focus on scaling the database and using it effectively, putting aside worrying about the security patches, for they are already being managed. AWS is highly efficient and scalable, balancing top security with low cost.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">It also has multiple database engines like Aurora, Postgres, MySQL, Microsoft SQL Server, Oracle, and MariaDB, to name a few.<\/span><\/p>\n<h2>SQL and Amazon RDS<\/h2>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">SQL is a self-managed database, i.e., you will have to manage the patching, updation of the security, and all the management of the database by yourself. This means managing the front end, backend, the database layer and more.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Amazon RDS is a relational database as a service, which enables it to handle failovers, software update patches, data backups, and optimization for you. So, the database is optimised, ready, and working and you don\u2019t have to worry about making the database work and operate. It supports 6 database engines including SQL server.\u00a0<\/span><\/li>\n<\/ul>\n<h2>Process Overview<\/h2>\n<p><img decoding=\"async\" class=\"aligncenter wp-image-81080 size-full\" title=\"MySQL migration process overview \" src=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process.png\" alt=\"MySQL migration process overview \" width=\"814\" height=\"457\" srcset=\"https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process.png 814w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process-300x168.png 300w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process-768x431.png 768w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process-748x420.png 748w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process-640x359.png 640w, https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/database-migration-process-681x382.png 681w\" sizes=\"(max-width: 814px) 100vw, 814px\" \/><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">Use the AWS DMS to connect SQL to RDS.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-weight: 400;\">Put SQL into EC2(Elastic Cloud Compute), which is a compute service that we rent from AWS, which means that we rent Virtual Machines for Cloud ops from AWS. This saves us from building all the infrastructure and the hardware, which is a costly and time consuming process.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-weight: 400;\">With the help of AWS, we are able to rent space from virtual machines that are ready to use and put the SQL database into a MySQL server, further executing it on EC2.<\/span><\/li>\n<\/ul>\n<ul>\n<li><span style=\"font-weight: 400;\">Use the AWS DMS to migrate the SQL to RDS and this is a fully managed service which is fast and secure, and helps us pipe our data from MySQL server into RDS, the relational database service.making it easy to build, implement and scale.<\/span><\/li>\n<\/ul>\n<h2>The Solution Architecture<\/h2>\n<ol>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Log in to the AWS Management Console provided by Whizlabs.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Built within an AWS Cloud region, a virtual private cloud that contains the Security Group, inside which we have an EC2 instance running on My SQL Server.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Create an instance of RDS as the database.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Create a task to migrate all the inputs of MySQL into RDS.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">The MySQL connects with <a href=\"https:\/\/aws.amazon.com\/dms\/\" target=\"_blank\" rel=\"nofollow noopener\">AWS DMS<\/a>, which further connects with AWS RDS, and then back the same. This is how the RDS is updated based on the inputs it is receiving.<\/span><\/li>\n<\/ol>\n<blockquote><p>Try Now <a href=\"https:\/\/play.whizlabs.com\/site\/task_details?task_id=29&amp;quest_id=31\" target=\"_blank\" rel=\"noopener\">Migration of Database Using DMS Labs<\/a><\/p><\/blockquote>\n<p><span style=\"font-weight: 400;\">The content has been defined thoroughly with great clarity on the concepts. Keep learning with us for more amazing content.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>AWS Database Migration Service (DMS) allows the migration of databases to AWS in a secure way. It also supports homogeneous migrations, for instance, Oracle to Oracle, along with heterogeneous migrations, i.e. between different database platforms like Oracle to Amazon Aurora. To date, over 5,50,000 databases have been migrated using the AWS DMS. Whizlabs conducted an elaborative webinar on \u2018AWS Database Migrations with DMS\u2019, with Mr. Brian H. Hough on 8th January, 2022. We have published a course about AWS DMS. The agenda of the Webinar was to learn: SQL AWS Serverless Database Ecosystem RDS AWS DMS Brian H. Hough is [&hellip;]<\/p>\n","protected":false},"author":359,"featured_media":81077,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"set","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[4,10,29],"tags":[],"class_list":["post-81065","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-aws-certifications","category-cloud-computing-certifications","category-webinar"],"uagb_featured_image_src":{"full":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",600,315,false],"thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms-150x150.png",150,150,true],"medium":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms-300x158.png",300,158,true],"medium_large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",600,315,false],"large":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",600,315,false],"1536x1536":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",600,315,false],"2048x2048":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",600,315,false],"profile_24":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",24,13,false],"profile_48":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",48,25,false],"profile_96":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",96,50,false],"profile_150":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",150,79,false],"profile_300":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",300,158,false],"tptn_thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms-250x250.png",250,250,true],"web-stories-poster-portrait":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",600,315,false],"web-stories-publisher-logo":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",96,50,false],"web-stories-thumbnail":["https:\/\/www.whizlabs.com\/blog\/wp-content\/uploads\/2022\/01\/migration-of-database-with-aws-dms.png",150,79,false]},"uagb_author_info":{"display_name":"Abilesh Premkumar","author_link":"https:\/\/www.whizlabs.com\/blog\/author\/abilesh\/"},"uagb_comment_info":3,"uagb_excerpt":"AWS Database Migration Service (DMS) allows the migration of databases to AWS in a secure way. It also supports homogeneous migrations, for instance, Oracle to Oracle, along with heterogeneous migrations, i.e. between different database platforms like Oracle to Amazon Aurora. To date, over 5,50,000 databases have been migrated using the AWS DMS. Whizlabs conducted an&hellip;","_links":{"self":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/81065","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/users\/359"}],"replies":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/comments?post=81065"}],"version-history":[{"count":15,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/81065\/revisions"}],"predecessor-version":[{"id":91595,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/posts\/81065\/revisions\/91595"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media\/81077"}],"wp:attachment":[{"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/media?parent=81065"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/categories?post=81065"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.whizlabs.com\/blog\/wp-json\/wp\/v2\/tags?post=81065"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}