'Oracle 19c (Linux) to Azure Managed PostgreSQL (single server - Windows)
We have a requirement to migrate Oracle 19c hosted on RHEL to Azure managed PostgreSQL. There are 2 options in Azure - 1) Single Server and 2) Flexible server
Single server installs PostgreSQL on windows while Flexible server uses linux. Besides the known in-compatibilities b/w Oracle and PostgreSQL, is there any thing additional to be considered while migrating from a Linux based DB (Oracle) to Windows based DB (Azure PostgreSQL - Single Server).
As per checking "NLS_DATABASE_PARAMETERS" in Oracle DB, I can see below parameters -
NLS_CHARACTERSET AL32UTF8
NLS_SORT BINARY
NLS_COMP BINARY
As per Azure postgresql single server documentation -
lc_collate English_United States.1252
lc_ctype English_United States.1252
lc_messages English_United States.1252
lc_monetary English_United States.1252
lc_numeric English_United States.1252
lc_time English_United States.1252
Is there anything specific to check to ensure seamless migration mainly w.r.t diff hosting environments (Linux Vs Windows)?
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|