{"id":1062,"date":"2024-11-14T01:38:20","date_gmt":"2024-11-14T01:38:20","guid":{"rendered":"https:\/\/192.168.1.3\/wordpress\/?p=1062"},"modified":"2025-06-26T01:02:07","modified_gmt":"2025-06-26T01:02:07","slug":"aws-certified-data-engineer-associate-dea-c01-review-material-application-discovery-and-migration-service","status":"publish","type":"post","link":"https:\/\/mylinuxsite.com\/wordpress\/?p=1062","title":{"rendered":"AWS Certified Data Engineer Associate (DEA-C01) Review Material \u2013 Application Discovery and Data Migration Service"},"content":{"rendered":"\n<!--more-->\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Application Discovery Service<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Collects usage and configuration data about your on-premises servers and databases.&nbsp;<\/li><li>All discovered data is stored in your AWS Migration Hub home Region.&nbsp;<\/li><li>Application Discovery Service APIs help you export the system performance and utilisation data for your discovered servers and network connections between servers.<\/li><li>Integrated with AWS Migration Hub and AWS Database Migration Service Fleet Advisor.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li>Two (2) ways of performing discovery and collecting data about your on-premises servers:<ol><li><strong>Agentless discovery<\/strong> (<strong>Agentless Collector<\/strong>)<ul><li>Works for VMWare installation only.<\/li><li>Deploy the Application Discovery Service Agentless Collector (Agentless Collector) (OVA file) through your VMware vCenter.&nbsp;<\/li><li>It&nbsp;identifies virtual machines (VMs) and hosts associated with the VMware vCenter.<\/li><li>It does not support physical servers<\/li><\/ul><\/li><li><strong>Agent-based discovery<\/strong> (<strong>Discovery Agent<\/strong>)<ul><li>Deploys the AWS Application Discovery Agent on each of the VMs and physical servers.<\/li><li>The&nbsp;agent is available for Windows and Linux operating systems.<\/li><li><em>Cannot<\/em> collect:<ul><li>Database configuration data<\/li><li>VM utilization metrics<\/li><li>Database utilization metrics<\/li><\/ul><\/li><\/ul><\/li><\/ol><\/li><\/ul>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Data Migration Service<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\"><li>Migrate relational databases, data warehouses, NoSQL databases, and other types of data stores<\/li><li>Migrate your data into the AWS Cloud or between combinations of cloud and on-premises setups.<\/li><li>Support homogenous  (same DB engine) and heterogeneous (different DB engine) migration.<\/li><li>Support copying data to non-DBs like:<ul><li>KDS<\/li><li>S3<\/li><li>Kafka<\/li><\/ul><\/li><li>Has the ability to discover your source data stores and convert source schemas.<\/li><li>Support continuous data replication <ul><li>by capturing ongoing changes after initial (full-load) migration.<\/li><li>This process is also called change data capture (<strong>CDC<\/strong>).<\/li><\/ul><\/li><li>At a basic level, <em>AWS DMS is a server in the AWS Cloud that runs replication software<\/em>. <ul><li>In short, you need an <strong>EC2<\/strong> <strong>instance<\/strong> that runs the replication in the same region (and preferably on the same VPC) <\/li><\/ul><\/li><li>AWS DMS creates the tables and associated primary keys if they don&#8217;t exist on the target. You can create the target tables yourself if you prefer. <\/li><li>Use <strong>DMS Fleet Advisor<\/strong> to collect metadata and performance metrics from multiple database environments.<ul><li>It collects metadata and metrics from your on-premises database and analytic servers from one or more central locations without the need to install it on every computer.&nbsp;<\/li><\/ul><\/li><li>You can also use the AWS Schema Conversion Tool (<strong>AWS SCT<\/strong>) to create some or all of the target tables, indexes, views, triggers, and so on.<ul><li>It is a standalone application that provides a project-based <em>user interface<\/em>.&nbsp;<\/li><li>Must be installed on a machine that has access to the data source<\/li><\/ul><\/li><li><em>AWS DMS does not migrate empty tables. <\/em>As a workaround, dummy data can be fed into the empty tables before the migration task to help migrate all the tables.<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\"><strong><span style=\"color:#2ceb0e\" class=\"has-inline-color\">Hands-On<\/span><\/strong><\/h3>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"dmsfleet\"><span class=\"has-inline-color has-ast-global-color-0-color\">DMS Fleet Advisor<\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>We will use VirtualBox VMs to simulate our on-prem infrastructure for this hands-on.<\/li><li>We must create two (2) VMs running on the same network (NAT Network). One of the VMs will run the <em>Data Collector<\/em>, and the other will run the OS and the database we will discover.<ul><li>Install Windows Server 2016 on VM no. 1. We need a Windows Server because the <em>Data Collector&nbsp;<\/em>only runs on Windows Server 2012 or higher. You can follow this <a rel=\"noreferrer noopener\" href=\"https:\/\/www.microsoft.com\/en-us\/evalcenter\/download-windows-server-2016\" data-type=\"URL\" data-id=\"https:\/\/www.microsoft.com\/en-us\/evalcenter\/download-windows-server-2016\" target=\"_blank\">link<\/a> to download an evaluation copy of the Windows Server.<ul><li>Configure your Windows Server as a DC and install ADDS. You will need to provide an LDAP server in your Data Collector, and since Windows Server comes with an LDAP server (ADDS), we can also use it as our LDAP server.<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"520\" class=\"wp-image-1142\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-45-19.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-45-19.png 1223w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-45-19-300x223.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-45-19-1024x760.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-45-19-768x570.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"508\" class=\"wp-image-1144\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-10-15-33.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-10-15-33.png 1222w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-10-15-33-300x218.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-10-15-33-1024x743.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-10-15-33-768x557.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li>Install the <em>Data Collector<\/em>. <ul><li>Create a <em>Data Collector<\/em> in AWS (Before this, you must have your IAM Roles and S3 bucket ready. Refer to this <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/fa-resources.html\" data-type=\"URL\" data-id=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/fa-resources.html\" target=\"_blank\">link<\/a> for details).<\/li><li>Download the local <em>Data Collector<\/em> from the link provided in the dashboard.<\/li><li>Run the installation program in the Windows Server (Note: You need to install .Net 4.8 before you can run the installer).<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"524\" class=\"wp-image-1143\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-08-06-49.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-08-06-49.png 1227w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-08-06-49-300x224.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-08-06-49-1024x766.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-08-06-49-768x575.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><\/ul><\/li><li>Install a Linux OS on VM no. 2. This VM will host our database and be scanned by the <em>Data Collector<\/em>. In this hands-on, I chose Ubuntu, but you can choose any flavor of Linux or use Windows OS.<ul><li>Install the MySQL server. This&nbsp;<a rel=\"noopener\" href=\"https:\/\/ubuntu.com\/server\/docs\/install-and-configure-a-mysql-server\" target=\"_blank\">link<\/a>&nbsp;will help you with the installation. After installation, you need to configure your MySQL configuration to allow connections from outside.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"300\" class=\"wp-image-1165\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-59-43.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-59-43.png 1707w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-59-43-300x129.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-59-43-1024x439.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-59-43-768x329.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-59-43-1536x659.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/>.<\/li><\/ul><\/li><li>Install SSH. The <em>Data Collector<\/em> uses SSH to connect to your VM to collect data about your OS.<\/li><li>Create a test database\/table and test data in the MySQL database. I will create the same test database\/table and use the same test data I used in this <a href=\"https:\/\/192.168.1.3\/wordpress\/?p=942#zeroetl\" data-type=\"URL\" data-id=\"https:\/\/192.168.1.3\/wordpress\/?p=942#zeroetl\">hands-on<\/a>.<\/li><li>Configure your VM to join the domain of VM no. 1. This <a href=\"https:\/\/ubuntu.com\/server\/docs\/how-to-set-up-sssd-with-active-directory\" data-type=\"URL\" data-id=\"https:\/\/ubuntu.com\/server\/docs\/how-to-set-up-sssd-with-active-directory\">link<\/a> provides instructions on how to make an Ubuntu OS join a Windows domain.<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"331\" class=\"wp-image-1145\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-46-46.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-46-46.png 1458w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-46-46-300x142.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-46-46-1024x485.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-46-46-768x363.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"520\" class=\"wp-image-1146\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-47-32.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-47-32.png 1222w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-47-32-300x223.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-47-32-1024x760.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-47-32-768x570.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><\/ul><\/li><li>Configure the <em>Data forwarding <\/em>and <em>LDAP servers<\/em> in the <em>Data Collector<\/em>.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"461\" class=\"wp-image-1147\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-48-20.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-48-20.png 1378w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-48-20-300x198.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-48-20-1024x675.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-12-15-48-20-768x506.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Run the <em>discovery<\/em>.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"375\" class=\"wp-image-1148\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-06-56.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-06-56.png 1522w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-06-56-300x161.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-06-56-1024x548.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-06-56-768x411.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Add the discovered OS and Database to the <em>Monitored Objects<\/em>:<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"408\" class=\"wp-image-1149\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-10-08.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-10-08.png 1528w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-10-08-300x175.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-10-08-1024x597.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-10-08-768x448.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Run the <em>Data Collection<\/em>:<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"403\" class=\"wp-image-1150\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-13-09.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-13-09.png 1519w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-13-09-300x173.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-13-09-1024x589.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-13-21-13-09-768x442.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>After a couple of hours, the data collection will be complete:<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"414\" class=\"wp-image-1155\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-07-45-22.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-07-45-22.png 1524w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-07-45-22-300x177.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-07-45-22-1024x605.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-07-45-22-768x454.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>You can then start to analyze the inventory:<ul><li>To analyze your inventory, click &#8216;Analyze Inventories&#8217;<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"376\" class=\"wp-image-1157\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-23-21.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-23-21.png 1573w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-23-21-300x161.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-23-21-1024x551.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-23-21-768x413.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-23-21-1536x826.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>You can also generate recommendations:<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"349\" class=\"wp-image-1156\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-32-13.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-32-13.png 1599w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-32-13-300x150.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-32-13-1024x511.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-32-13-768x383.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-09-32-13-1536x767.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"sct\"><span class=\"has-inline-color has-ast-global-color-0-color\">Schema Conversion Tool (SCT)<\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>In this hand-on we will convert the MySQL schema in our VM to PostgreSQL schema.<\/li><li>We will continue to use one of VMs we used in <a href=\"#dmsfleet\" data-type=\"internal\" data-id=\"#dmsfleet\">this<\/a> hands-on, but we need to make changes in our VirtualBox Nat Network setting. The SCT instance in AWS must connect to our MySQL database on our Linux machine. So, we need to create a Port Forwarding rule that would forward traffic from our host to the VirtualBox VM hosting our MySQL database. We must also ensure our host&#8217;s firewall does not block our chosen port. In this hands-on, I used host port 53306.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"466\" class=\"wp-image-1173\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-10-17-10.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-10-17-10.png 850w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-10-17-10-300x200.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-10-17-10-768x511.png 768w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Create an AWS RDS PostgreSQL database. We will use AWS RDS PostgreSQL as our target database and convert our MySQL schema to a PostgreSQL schema.<\/li><li>From the AWS DMS console, create two (2) Data Providers.<ul><li>The first Data Provider is the source, the MySQL database. In your Data Provider configuration, use the VirtualBox host IP and the host port in your Port Forwarding Rules as your server and port.<\/li><\/ul><ul><li>The 2nd Data Provider is the AWS RDS PostgreSQL instance. <\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"153\" class=\"wp-image-1176\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-12-06-13.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-12-06-13.png 1588w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-12-06-13-300x66.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-12-06-13-1024x224.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-12-06-13-768x168.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-12-06-13-1536x337.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Create an Instance Profile:<ul><li>Select a VPC where the SCT instance will run and create a Subnet Group. To make it simple, use the Default VPC because this already have a public subnet.<\/li><li>Create an Instance Profile with a Public IP.<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"370\" class=\"wp-image-1177\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-18-11.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-18-11.png 1617w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-18-11-300x158.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-18-11-1024x541.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-18-11-768x406.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-18-11-1536x811.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Create a Migration Project:<ul><li>Create users in your source and target databases. This <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-source.html\" data-type=\"URL\" data-id=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-source.html\" target=\"_blank\">link<\/a> and this <a rel=\"noreferrer noopener\" href=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-target.html\" data-type=\"URL\" data-id=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-target.html\" target=\"_blank\">link<\/a> describe the roles and privileges your source and target users will need. Afterwards, create two (2) secrets in the AWS Secret Manager to store the usernames and passwords of these database users.<\/li><li>Create an S3 bucket that DMS uses to store schema conversion metadata.<\/li><li>Create the necessary IAM Roles. You need IAM Roles to access the secrets in the Secret Manager and store data in S3.<\/li><li>Create a Migration Project.<ul><li>For this hands-on, we will prefix the table name in the target database with &#8216;pg&#8217;. We will define this in the Migration Project&#8217;s Transformation Rule.<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"372\" class=\"wp-image-1178\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-20-42.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-20-42.png 1600w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-20-42-300x159.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-20-42-1024x544.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-20-42-768x408.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-15-14-20-42-1536x816.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><\/ul><\/li><li>Perform Schema Conversion:<ul><li>From the  Schema Conversion tab of the Migration Project, launch the schema conversion.<\/li><li>Under the Source Schema window pane of the Schema Conversion dashboard, convert the source schema.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"318\" class=\"wp-image-1181\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-04.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-04.png 1878w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-04-300x136.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-04-1024x465.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-04-768x349.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-04-1536x698.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li>When the process completes, you should see a new database\/table under the Target Schema windows pane. The table name should be prefixed with &#8216;pg&#8217;. <\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"308\" class=\"wp-image-1182\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-58.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-58.png 1920w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-58-300x132.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-58-1024x451.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-58-768x338.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-02-58-1536x677.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li>Note that these are not yet effective in your target database. You need to apply the changes.<\/li><\/ul><\/li><li>Apply the changes to your target database.<ul><li>Right-click on the target schema and click &#8216;Apply&#8217;. <\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"338\" class=\"wp-image-1184\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-24-52.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-24-52.png 1915w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-24-52-300x145.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-24-52-1024x494.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-24-52-768x371.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-24-52-1536x741.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li>Once the process is complete, verify that the database and tables have been created successfully in your target database.<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"137\" class=\"wp-image-1183\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-38-19.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-38-19.png 1914w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-38-19-300x59.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-38-19-1024x201.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-38-19-768x150.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-16-38-19-1536x301.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<h4 class=\"wp-block-heading\"><span class=\"has-inline-color has-ast-global-color-0-color\">Migrate Data<\/span><\/h4>\n\n\n\n<ul class=\"wp-block-list\"><li>In this hands-on, we will migrate the data from our VirtualBox MySQL database to an AWS RDS PostgreSQL database.<\/li><li>We will continue to use the same VM we used in <a href=\"#sct\" data-type=\"internal\" data-id=\"#sct\">this<\/a> hands-on.<\/li><li>Create two (2) <em>Endpoints<\/em>:<ul><li>Create users in your source and target databases. This <a href=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-source.html\" data-type=\"URL\" data-id=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-source.html\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a> and this <a href=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-target.html\" data-type=\"URL\" data-id=\"https:\/\/docs.aws.amazon.com\/dms\/latest\/userguide\/dm-data-providers-target.html\" target=\"_blank\" rel=\"noreferrer noopener\">link<\/a> describe the roles and privileges your source and target users will need. Afterwards, create two (2) secrets in the AWS Secret Manager to store the usernames and passwords of these database users.<\/li><li>Create the necessary IAM Roles. You need IAM Roles to access the secrets in the Secret Manager.<\/li><li>Create the source endpoint and then test the connection.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"243\" class=\"wp-image-1196\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56.png 1595w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-300x104.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-1024x355.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-768x266.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-1536x533.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"243\" class=\"wp-image-1196\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56.png 1595w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-300x104.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-1024x355.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-768x266.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-56-1536x533.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Create the target endpoint and then test the connection.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"306\" class=\"wp-image-1194\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-30.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-30.png 1596w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-30-300x131.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-30-1024x448.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-30-768x336.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-30-1536x672.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"202\" class=\"wp-image-1195\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-49.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-49.png 1593w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-49-300x86.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-49-1024x295.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-49-768x221.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-13-49-1536x443.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><\/ul><\/li><li>Create a <em>Replication Instance<\/em>:<ul><li>Choose <em>dms.t2.micro<\/em> for your instance class since this will be eligible for Free Tier.<\/li><li>Assign a Public IP to your instance to connect to your MySQL database.<\/li><li>For the VPC, I suggest using the Default VPC so you can reuse the subnet group you created in the previous hands-on.<\/li><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"371\" class=\"wp-image-1198\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-22.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-22.png 1622w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-22-300x159.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-22-1024x542.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-22-768x407.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-12-22-1536x813.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Create a Database Migration Task:<ul><li>Use the Replication Instance and Endpoints you created previously.<\/li><li>You can choose &#8216;Migrate&#8217; or &#8216;Migrate and replicate&#8217; for the Migration type.<\/li><li>If you want to try CDC, enable binary logging in your MySQL database.<\/li><li>Under the Mapping rules, create a Transformation rule that would add a prefix of &#8216;pg&#8217; to the target table name.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"323\" class=\"wp-image-1201\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-58-30.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-58-30.png 1595w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-58-30-300x138.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-58-30-1024x473.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-58-30-768x354.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-58-30-1536x709.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>If you leave the default setting of the &#8216;Migration task startup configuration&#8217;, the migration should start immediately once the task is created. <ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"380\" class=\"wp-image-1199\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-20-00-27-1.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-20-00-27-1.png 1570w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-20-00-27-1-300x163.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-20-00-27-1-1024x556.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-20-00-27-1-768x417.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-20-00-27-1-1536x835.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>You can also run a Premigration Assessment to see if everything is configured correctly.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"373\" class=\"wp-image-1200\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-23-30.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-23-30.png 1597w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-23-30-300x160.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-23-30-1024x546.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-23-30-768x410.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-23-30-1536x819.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Once the migration is complete, you can look at the Table statistics tab to see how many records have been migrated.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"302\" class=\"wp-image-1202\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-57-09.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-57-09.png 1580w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-57-09-300x129.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-57-09-1024x442.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-57-09-768x332.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-57-09-1536x663.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/><\/li><\/ul><\/li><li>Validate the result by counting the records in the AWS RDS PostgreSQL database.<ul><li><img loading=\"lazy\" decoding=\"async\" width=\"700\" height=\"190\" class=\"wp-image-1204\" style=\"width: 700px;\" src=\"http:\/\/192.168.1.3\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-52-58.png\" alt=\"\" srcset=\"https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-52-58.png 1920w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-52-58-300x81.png 300w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-52-58-1024x277.png 1024w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-52-58-768x208.png 768w, https:\/\/mylinuxsite.com\/wordpress\/wp-content\/uploads\/2024\/11\/Screenshot-from-2024-11-14-19-52-58-1536x416.png 1536w\" sizes=\"auto, (max-width: 700px) 100vw, 700px\" \/> <\/li><\/ul><\/li><\/ul><\/li><\/ul>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":true,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","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":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","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":[11],"tags":[],"class_list":["post-1062","post","type-post","status-publish","format-standard","hentry","category-aws-review-notes"],"_links":{"self":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1062","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1062"}],"version-history":[{"count":44,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1062\/revisions"}],"predecessor-version":[{"id":1562,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/1062\/revisions\/1562"}],"wp:attachment":[{"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mylinuxsite.com\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}