https://community.esri.com/t5/arcgis-enterprise-questions/suggestions-for-migrating-from-sql-server/m-p/1373596#M38343 <P>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".</P><P>It's an old article, but you can start with this PostgreSQL wiki page on the topic: <A href="https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding" target="_blank">https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding</A></P> Tue, 23 Jan 2024 19:00:19 GMT jcarlson 2024-01-23T19:00:19Z https://community.esri.com/t5/arcgis-enterprise-questions/suggestions-for-migrating-from-sql-server/m-p/1373479#M38338 <P>My upper management is "suggesting" moving away from SQL Server Enterprise Databases to PostgreSQL when me move to the cloud.&nbsp; Does ESRI, or anyone else, have migration suggestions written up or FAQs?</P><P>Thanks</P> Tue, 23 Jan 2024 16:01:01 GMT https://community.esri.com/t5/arcgis-enterprise-questions/suggestions-for-migrating-from-sql-server/m-p/1373479#M38338 RandyKreuziger1 2024-01-23T16:01:01Z https://community.esri.com/t5/arcgis-enterprise-questions/suggestions-for-migrating-from-sql-server/m-p/1373596#M38343 <P>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".</P><P>It's an old article, but you can start with this PostgreSQL wiki page on the topic: <A href="https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding" target="_blank">https://wiki.postgresql.org/wiki/Microsoft_SQL_Server_to_PostgreSQL_Migration_by_Ian_Harding</A></P> Tue, 23 Jan 2024 19:00:19 GMT https://community.esri.com/t5/arcgis-enterprise-questions/suggestions-for-migrating-from-sql-server/m-p/1373596#M38343 jcarlson 2024-01-23T19:00:19Z