Check out the Learning page on the Safe Software web site.
There are tutorials for both the basic Desktop product (I recommend doing that first) and then one for Spatial Databases. Those two should get you going in no time.
We (I work at Safe) don't put prices out there because there are so many licensing options (and resellers) and we want to make sure users get the product they need. There are also fixed and floating licenses which complicates matters. To write to SQL Server you'll need a 'database' edition (there are several with different names but basically the same functionality).
I suspect the price will be a little higher than the numbers quoted here which I think would be for the lower-level Professional Edition. But I don't work for the sales team so I can't really be sure. But there's no secret to them; just contact our sales team or your local reseller and they will be happy to give you a price.
it depends on the Version of Qgis Lisboa you use.
There is a bug in Qgis standalone installer for Windows which prevents the synchronisation of Qgis own CRS database with that of Gdal, if the installation path contains blanks (which is default). The Osgeo4w Installer does it correct by now, and supplies EPSG:3814 from GDAL to qgis:
+proj=tmerc +lat_0=32.5 +lon_0=-89.75 +k=0.9998335 +x_0=500000 +y_0=1300000 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=m +no_defs
If Qgis is not sure whether the .prj file is identical to a EPSG, it rather creates its own CRS. Missing towgs84 parameters could be a reason. The .prj file contains a WKT formatted CRS definition.
spatialreference.org gives this WKT definition for 3814:
PROJCS["NAD83 / Mississippi TM",
GEOGCS["NAD83",
DATUM["North American Datum 1983",
SPHEROID["GRS 1980",6378137.0,298.257222101,
AUTHORITY["EPSG","7019"]],
TOWGS84[1.0,1.0,-1.0,0.0,0.0,0.0,0.0],
AUTHORITY["EPSG","6269"]],
PRIMEM["Greenwich",0.0,
AUTHORITY["EPSG","8901"]],
UNIT["degree",0.017453292519943295],
AXIS["Geodetic latitude",NORTH],
AXIS["Geodetic longitude",EAST],
AUTHORITY["EPSG","4269"]],
PROJECTION["Transverse Mercator",
AUTHORITY["EPSG","9807"]],
PARAMETER["central_meridian",-89.75],
PARAMETER["latitude_of_origin",32.5],
PARAMETER["scale_factor",0.9998335],
PARAMETER["false_easting",500000.0],
PARAMETER["false_northing",1300000.0],
UNIT["m",1.0],
AXIS["Easting",EAST],
AXIS["Northing",NORTH],
AUTHORITY["EPSG","3814"]]
The towgs84 parameters differ. EPSG notes 0;0;0 for mainland USA, and 1;1;-1 only for Hawaii.
The EPSG registry at http://www.epsg-registry.org/
has almost identical values vor EPSG:3813 and 3814.
I'm not sure if qspatialite uses the Qgis CRS database or that of spatialite itself for the input mask.
Can you insert the .prj and qgis made Custom CRS string here?
Best Answer
You can use the following:
To check it worked, first use SQL to verify the values were written correctly:
(don't use distinct)
You might also ensure the coordinates are in WGS84 by selecting the geometry as text:
Then, can you add the data to QGIS to ensure it draws correctly?