[mapguide-users] Advantages of storing spatial data in SQL Server

[Warren Medernach]

Hello Kalpesh,

The advantages are many...
- Data in a single location reduces redundancy
- Easier maintenance (backing up a single database vs. multiple files
scattered around)
- Security standards for data access can be established and enforced
- A DBMS is better suited to managing large numbers of concurrent users.

Disadvantages...
- Higher cost with respect to aquiring and maintaining
- Adds complexity, escpecially in smaller projects

By no means is this a complete list...
   Warren Medernach

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of kalpesh
Sent: Saturday, March 31, 2007 2:41 AM
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] Advantages of storing spatial data in SQL
Server


Hi,
What are the advantages of storing Mapguide spatial data in Oracle or
SQL instead of the native storage on the file system ? I was looking at
it from the perspective of stability, digitizing functionality and day
to day management of data. 

- Kalpesh
--
View this message in context:
http://www.nabble.com/Advantages-of-storing-spatial-data-in-SQL-Server-t
f3496205s16610.html#a9765315
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users