Moving away from Full SQL Server

TimSaksa

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.....

RichardWatson

What cost are you taking about?

Is it the cost to purchase the software, the cost to have maintenance/support, or the cost of your time maintaining it?

I think that you need a table which lists all the costs for all databases so that you can compare them.

Of course, SQL Express is much less functional but if you load is so small that it works for you then go for it.

Another solution is to just use a file geodatabase.  You have not told us why you even need a RDBMS.