In our project we deside to convert all layers type shapefile layer, tablfile layer,...) to SQL-Server2008 layer and then working with it inside the application.
do you think this convert will increase the performance or decrease?
do you think it's good ides?
does it possible to convert all the layer type to SQLServer2008 layer and vice versa?
regards,
Ben
Hi,
About the performance difference between VS2008 and Shape File, please have a look at a thread here. Generally, if the data is on a remote machine, SQL2008 is a bit faster than shape file, but if it is on local machine, shape file will be faster as it can be well cached.
gis.thinkgeo.com/Support/Dis...fault.aspx
About the conversions, I think you can convert all types of shapefile to Sql2008, but cannot do the other way. That’s because one shape file can only hold one type of shapes, but SQL2008 can hold multi types of shapes (like point and polygon) in one table. That means you cannot convert one SQL2008 table to a corresponding shape file.
The following link shows how to use a tool to convert data from Shapefile to Sql2008.
gis.thinkgeo.com/Support/Dis...fault.aspx
Thanks,
Ben