c# - What database should I use that would best suit my GIS application? -

i in process of developing program , not sure go here...

i using visual c# , dotspatial frawework in order gis/gps side of things unsure of end database use.

i have had @ postgrsql postgis , had @ mssql has geospatial capabilities.

so trying achieve following software: - software needs used both @ persons desk, remotely while using gis/gps side of system track users travelling. (i.e. when locating need go - custom data on remote sites). relatively easy dotspatial alone , not db needed. - have custom forms capture data (text, lats/longs, photos) while out on site. - data needs able sync main database when in office - data needs viewable connected system once system updated

ultimately if can type of dms great. keeping in mind well.

should use seperate db datacapture side of things , else main db or should use same both? 1 easiest configure? prefer when deploying software installation goes smootly , dont have manually configure each machine.

the main server windows 2008 server btw.

any or suggestions appreciated.

i use postgresql postgis on daily basis. although opensource provides funcionality , performance.

check cross compare between sql server 2008 spatial, postgresql/postgis 1.3-1.4, mysql 5-6. give idea