Q92Design High-Performing ArchitecturesMultiple answers
A company uses a Microsoft SQL Server database, and the company's applications are connected to that database. The company wants to migrate to an Amazon Aurora PostgreSQL database while making minimal changes to the application code. Which combination of steps will satisfy these requirements? **(Choose two.)**
Select 2 answers.
← → navigate · a answer
Community votes
Discussion · 6
B, C 7
B: Babelfish for Aurora PostgreSQL is a new capability for Amazon Aurora PostgreSQL-Compatible Edition that enables Aurora to understand commands from applications written for Microsoft SQL Server.
C: Is just obvious: Use Data Migration Tool for the migration, Schema Conversion tool for the Schema conversion.
B, C 4
https://aws.amazon.com/rds/aurora/babelfish/
B, C 3
A - AWS SCT does not directly rewrite SQL queries in the application code. This would require manual updates.
B - Babelfish allows Aurora PostgreSQL to understand SQL Server’s native T-SQL language and protocol.
C - Convert the schema & migrate the data effectively, good.
D - Amazon RDS Proxy improves database scalability and availability (if the question mentions something like having trouble conneting during peek hours or whatnot then RDS Proxy is likely the answer) but does not address the compatibility issues between SQL Server and Aurora PostgreSQL.
E - This is not enough. Refer to option C.
3
https://aws.amazon.com/rds/aurora/babelfish/
B, C 2
DMS + SCT is correct, but " rewrite the SQL queries in the applications." is wrong so A + E are out.
Then only left B + C -> DMS + SCT + Babekfish (for SQL Server)
B, C 2
AnswerBC
DMS will allow for DATABASE migration and use AWS Schema Conversion Tool (AWS SCT) to create some or all of the target tables, indexes, views, triggers, and so on.
https://docs.aws.amazon.com/dms/latest/userguide/Welcome.html
To minimalize amount of code which need to me changes we need to use babelfish
https://aws.amazon.com/rds/aurora/babelfish/