AWS prescriptive-guidance documentation change
Summary
Updated formatting and punctuation: changed curly quotes to straight quotes in multiple sections, removed markdown bold syntax from table headers, and updated author attribution format.
Security assessment
The changes are purely stylistic/formatting improvements (quote normalization, markdown syntax adjustments) with no mention of security vulnerabilities, access controls, encryption, or authentication mechanisms. No new security-related content was added or modified beyond formatting.
Diff
diff --git a/prescriptive-guidance/latest/patterns/validate-database-objects-after-migrating-from-oracle-to-amazon-aurora-postgresql.md b/prescriptive-guidance/latest/patterns/validate-database-objects-after-migrating-from-oracle-to-amazon-aurora-postgresql.md index 2fcd565d2..d81247827 100644 --- a//prescriptive-guidance/latest/patterns/validate-database-objects-after-migrating-from-oracle-to-amazon-aurora-postgresql.md +++ b//prescriptive-guidance/latest/patterns/validate-database-objects-after-migrating-from-oracle-to-amazon-aurora-postgresql.md @@ -9 +9 @@ SummaryPrerequisites and limitationsArchitectureToolsEpicsRelated resourcesAttac - _Created by Venkatramana Chintha (AWS) and Eduardo Valentim (AWS)_ + _Venkatramana Chintha and Eduardo Valentim, Amazon Web Services_ @@ -58 +58 @@ This pattern outlines usage scenarios and steps for database object validation; -To validate the objects, use the full scripts in the "Object validation scripts" file in the “Attachments” section. Use the following table for reference. +To validate the objects, use the full scripts in the "Object validation scripts" file in the "Attachments" section. Use the following table for reference. @@ -60 +60 @@ To validate the objects, use the full scripts in the "Object validation scripts" -**Oracle object**| **Script to use** +Oracle object| Script to use @@ -72 +72 @@ Foreign keys | Query 17 -**PostgreSQL object**| **Script to use** +PostgreSQL object| Script to use @@ -88,9 +88,9 @@ Task| Description| Skills required -Run the “packages” validation query in the source Oracle database. | Download and open the “Object validation scripts” file from the “Attachments” section. Connect to the source Oracle database through your client program. Run the “Query 1” validations script from the “Object validation scripts” file. Important: Enter your Oracle user name instead of “your_schema” in the queries. Make sure you record your query results.| Developer, DBA -Run the “tables” validation query. | Run the “Query 3” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “views” validation query. | Run the “Query 5” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “sequences” count validation. | Run the “Query 7” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “triggers” validation query. | Run the “Query 9” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “primary keys” validation query. | Run the “Query 11” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “indexes” validation query. | Run the “Query 13” validation script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “check constraints” validation query. | Run the “Query 15” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “foreign keys” validation query. | Run the “Query 17” validation script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA +Run the "packages" validation query in the source Oracle database. | Download and open the "Object validation scripts" file from the "Attachments" section. Connect to the source Oracle database through your client program. Run the "Query 1" validations script from the "Object validation scripts" file. Important: Enter your Oracle user name instead of "your_schema" in the queries. Make sure you record your query results.| Developer, DBA +Run the "tables" validation query. | Run the "Query 3" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "views" validation query. | Run the "Query 5" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "sequences" count validation. | Run the "Query 7" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "triggers" validation query. | Run the "Query 9" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "primary keys" validation query. | Run the "Query 11" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "indexes" validation query. | Run the "Query 13" validation script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "check constraints" validation query. | Run the "Query 15" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "foreign keys" validation query. | Run the "Query 17" validation script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA @@ -100,10 +100,10 @@ Task| Description| Skills required -Connect to the target Aurora PostgreSQL-Compatible database by using the query editor.| Sign in to the AWS Management Console and open the Amazon RDS console. In the upper-right corner, choose the AWS Region in which you created the Aurora PostgreSQL-Compatible database. In the navigation pane, choose “Databases,” and choose the target Aurora PostgreSQL-Compatible database. In “Actions,” choose “Query.” Important: If you haven't connected to the database before, the “Connect to database” page opens. You then need to enter your database information, such as user name and password.| Developer, DBA -Run the “packages” validation query.| Run the “Query 2” script from the “Object validation scripts” file in the “Attachments” section. Make sure you record your query results.| Developer, DBA -Run the “tables” validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the “Query 4” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “views” validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the “Query 6” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “sequences” count validation. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the “Query 8” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “triggers” validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the “Query 10” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “primary keys” validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the “Query 12” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “indexes” validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the “Query 14” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “check constraints” validation query. | Run the “Query 16” script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA -Run the “foreign keys” validation query. | Run the “Query 18” validation script from the “Object validation scripts” file. Make sure you record your query results.| Developer, DBA +Connect to the target Aurora PostgreSQL-Compatible database by using the query editor.| Sign in to the AWS Management Console and open the Amazon RDS console. In the upper-right corner, choose the AWS Region in which you created the Aurora PostgreSQL-Compatible database. In the navigation pane, choose "Databases," and choose the target Aurora PostgreSQL-Compatible database. In "Actions," choose "Query." Important: If you haven't connected to the database before, the "Connect to database" page opens. You then need to enter your database information, such as user name and password.| Developer, DBA +Run the "packages" validation query.| Run the "Query 2" script from the "Object validation scripts" file in the "Attachments" section. Make sure you record your query results.| Developer, DBA +Run the "tables" validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the "Query 4" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "views" validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the "Query 6" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "sequences" count validation. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the "Query 8" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "triggers" validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the "Query 10" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "primary keys" validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the "Query 12" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "indexes" validation query. | Return to the query editor for the Aurora PostgreSQL-Compatible database, and run the "Query 14" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "check constraints" validation query. | Run the "Query 16" script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA +Run the "foreign keys" validation query. | Run the "Query 18" validation script from the "Object validation scripts" file. Make sure you record your query results.| Developer, DBA