Our company has millions of feature classes currently stored through ArcSDE on SQL Server 2008 R2. We are kind of slowly making our way to opensource software.
What we want to achieve is to be able to migrate all our spatial data off ESRI to opensource database, and then be able to publish the data to our intranet, and allow end users to search and view the data.
I have been thinking of a solution stack of of PostgresSQL/PostGIS, GeoNetwork and GeoServer. How much time/effort would you expect it to be? Any other best-practice recommendations?