AnsweredAssumed Answered

PostgreSQL as alternative to SQL Server Express

Question asked by dbecker88 on Mar 9, 2017
Latest reply on May 23, 2017 by dbecker88

We're upgrading our current GIS box and would like to improve upon our current SQL Server Express instance.

I want the RDBMS to utilize the expanded system resources of the new box and Express just can't do that.

 

I just got the quote to upgrade to SQL Server Standard 2014 (minimum 4-core license) and about lost my lunch, so I'm looking for alternatives and PostgreSQL looks promising.

 

New box will run Hyper-V Core, then virtual OSEs

  • VM-1 -- MS Server 2012 Std; Domain Controller
  • VM-2 -- MS Server 2012 Std; ArcGIS Server
  • VM-3 -- Ubuntu Server 16.04 LTS; PostgreSQL

 

I assume that adding database server connection to PostgreSQL in ArcGIS Desktop will be a similar experience?

After the connection is made, can I simply right click and "create new geodatabase"? 

 

I guess I just am looking for the differences in user experience when interacting with a PostgreSQL backend vs. SQL Server.

 

thanks!

Outcomes