tsaksa1

Moving away from Full SQL Server

Discussion created by tsaksa1 on Jun 25, 2013
Latest reply on Jul 2, 2013 by ciava.at
Okay true discussion topic. 

I was told to do research on moving away from the full SQL Server software.  As a whole we don't have enough workload to justify the cost of upkeep on the software.  Question is where should we go????  Should we just downgrade to a SQL Server Express license or change platforms all together?  We publish map services that are updated real time via our Enterprise license.  We cannot lose that capability.  I would imagine that all of the database platforms would support this functionality.  I have looked into PostgreSQL, and DB2 (IBM).  Both seem capable but the only experience I have with database management has been with SQL Server.  I am thinking of ease of data transfer and workability. 


Software versions:
ArcDesktop 10.1 SP1 (Standard)
ArcServer 10.1
SQL Server 2008 R2

I am just looking for insight on previous experience with changing database platforms.

Thanks.....

Outcomes