Inspect Target Database

Contents

Inspect the Content of Target Database

If you disconnected from the EC2 instance, follow the instruction in Connect to the EC2 Instance section from the previous part to RDP to the instance.

  1. Open pgAdmin4 from within the EC2 server, and then connect to the Target Aurora RDS (PostgreSQL) database connection that you created earlier.
  2. Inspect the migrated data, by querying one of the tables in the target database. For example, the following query should return a table with two rows:
SELECT *
FROM dms_sample.sport_type;

Inspect

Baseball, and football are the only two sports that are currently listed in this table. In the next section you will insert several new records to the source database with information about other sport types. DMS will automatically replicate these new records from the source database to the target database.

  1. Now, use the following script to enable the foreign key constraints that we dropped earlier:

Before we add foreign key constraints make sure that migration tasks are 100% load-complete to avoid error

		<li>
			<a href="/2-oracle-aurora/2-migration/7-inspect-content/_index.files/AddConstraintsPostgreSQL.sql" >
				AddConstraintsPostgreSQL.sql
			</a>
			(3 ko)
		</li>

<div>