New PostgreSQL migration extension for Azure Data Studio now in Public Preview
Published Mar 01 2023 09:30 AM 3,448 Views
Microsoft

Azure Data Studio migration extensions continue to expand to help you accelerate any database migration to Azure. I am pleased to share that the new Azure PostgreSQL migration extension for Azure Data Studio (ADS) offers an assessment capability to identify when a PostgreSQL server instance is ready to be moved to Azure. Database assessments are a fundamental step to help users understand the value of cloud migrations and make strategic decisions for moving into Azure services, such as Azure Database for PostgreSQL.

 

Azure Database for PostgreSQL is a relational database platform based on the open-source Postgres database engine and allows you to focus on app development instead of database management. As a fully managed intelligent database, you can scale your workload quickly with ease and accelerate your time to market rather than allocating precious time and resources to managing virtual machines and infrastructure. Azure Database for PostgreSQL supports the latest Postgres versions with a wide range of popular extensions, making it the up-to-date, secure, cost-effective, and performant database platform for your enterprise PostgreSQL workloads.

 

To help migrate and modernize PostgreSQL to Azure Database for PostgreSQL, we are announcing the “Azure PostgreSQL migration extension for Azure Data Studio” powered by Azure Database Migration Service, which helps assess PostgreSQL databases to Azure and provides the migration readiness status for the PostgreSQL Server instance. In addition, you can see the recommended target instance in Azure, potential migration blockers, warnings, and readiness for Azure Database for PostgreSQL - Flexible Server at a compatibility level, an instance level, and a database level. Azure Data Studio is a popular tool used by database administrators, data operations professionals, and developers to manage databases both on-premises and in the cloud. As part of this Public Preview announcement, the extension will only support PostgreSQL Server instance assessments.

 

GIF showcasing the complete steps to perform assessment.gif

Simplify assessments with Azure PostgreSQL migration extension

 

Starting today, the new Azure PostgreSQL migration extension is available in the Azure Data Studio marketplace. Azure Data Studio provides flexibility as a cross-platform database tool for data professionals who use on-premises and cloud data platforms on Windows, MacOS, and Linux.

 

The Azure PostgreSQL migration extension in Azure Data Studio brings together a mechanism for simplified assessments and recommendations to migrate PostgreSQL Server instances to Azure. This preview version delivers the following capabilities:

  • A responsive user interface with an easy-to-navigate step-by-step wizard to deliver an integrated assessment and Azure Database for PostgreSQL target.
  • An enhanced assessment engine that can assess PostgreSQL Server instances and identify databases that are ready for a migration to Azure Database for PostgreSQL.
  • A recommendation engine to collect performance data from the source PostgreSQL Server instance to generate rightsized Azure PostgreSQL recommendations.
  • Create HTML reports on assessment results.

 

Right sizing recommendations for PostgreSQL database migrations to Azure Database for PostgreSQL

 

Right sizing a target workload in Azure can be a challenging task. The extension analyses the performance metadata from the PostgreSQL server and operating system and suggests a suitable Azure Database for PostgreSQL target by evaluating performance metrics such as CPU, memory, storage, and IOPS. Users can view details about the reason behind the Azure target recommendation and the source properties that were analyzed.

 

Assessment Summary Result performed on source PostgreSQL Instances.png

 

Next Steps

 

 We are always eager to hear from you, reach out to epgsupport@microsoft.com with your feedback and suggestions.

Version history
Last update:
‎Mar 01 2023 05:48 AM
Updated by: