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.