![]() When using a firewall appliance in front of your source database(s), you may need to add firewall rules to allow the Azure Database Migration Service to access the source database(s) for migration.Ĭreate a server-level firewall rule for Azure Database for PostgreSQL to allow Azure Database Migration Service to access to the target databases. Open your Windows firewall to allow Azure Database Migration Service to access the source PostgreSQL Server, which by default is TCP port 5432. For more detail on virtual network NSG traffic filtering, see the article Filter network traffic with network security groups.Ĭonfigure your Windows Firewall for database engine access. This configuration is necessary because Azure Database Migration Service lacks internet connectivity.Įnsure that the Network Security Group (NSG) rules for your virtual network don't block the outbound port 443 of ServiceTag for ServiceBus, Storage and AzureMonitor. Target database endpoint (for example, SQL endpoint, Azure Cosmos DB endpoint, and so on).For more information about creating a virtual network, see the Virtual Network Documentation, and especially the quickstart articles with step-by-step details.ĭuring virtual network setup, if you use ExpressRoute with network peering to Microsoft, add the following service endpoints to the subnet in which the service will be provisioned: For example, PostgreSQL 12 can migrate to Azure Database for PostgreSQL >= 12 version but not to Azure Database for PostgreSQL 11.Ĭreate an Azure Database for PostgreSQL server.Ĭreate a Microsoft Azure Virtual Network for Azure Database Migration Service by using the Azure Resource Manager deployment model, which provides site-to-site connectivity to your on-premises source servers by using either ExpressRoute or VPN. For more information, see Supported PostgreSQL database versions.Īlso note that the target Azure Database for PostgreSQL version must be equal to or later than the on-premises PostgreSQL version. The source PostgreSQL Server version must be >= 9.4. Prerequisitesĭownload and install PostgreSQL community edition. Moving data across regions or geographies can slow down the migration process and introduce errors. For an optimal migration experience, Microsoft recommends creating an instance of Azure Database Migration Service in the same Azure region as the target database.
0 Comments
Leave a Reply. |