This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Choose the best response for each of the following questions.
A PostgreSQL database server at version 11.22 needs an online migration to Azure Database for PostgreSQL - Flexible Server running PostgreSQL version 14. Which tools or services can be used to perform this migration?
Azure Database for PostgreSQL Flexible Server Migration.
pg_dump and pg_restore.
Database Migration Service.
An offline migration is being performed from an existing PostgreSQL server to Azure Database for PostgreSQL - Flexible Server. To transfer server-level roles from the source to the target, which combination of tools should be used?
pg_dumpall, psql, and Azure Database for PostgreSQL - Flexible Server Migration.
psql and Database Migration Service.
Before performing a database migration from a source PostgreSQL server to a target, it's necessary to assess whether there are any blockers. Which tool should be used for this assessment?
pg_dumpall.
Azure Data Studio with Azure PostgreSQL migration extension.
You must answer all questions before checking your work.
Was this page helpful?