Suggestions for Migrating from SQL Server Enterprise Databases to PostgresSQL

[RandyKreuziger1]

My upper management is "suggesting" moving away from SQL Server Enterprise Databases to PostgreSQL when me move to the cloud.  Does ESRI, or anyone else, have migration suggestions written up or FAQs?

Thanks

[jcarlson]

My suggestion: make a throwaway PostgreSQL database (Docker is great for this) and test importing items. As much as possible, do this with a script of some kind to make it easily replicable, and test it a lot before doing it "for real".

It's an old article, but you can start with this PostgreSQL wiki page on the topic: https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding