Is it's possible to connect ArcGIS Server for WorkGroup to full MSSQL?

1609
10
Jump to solution
04-03-2014 10:58 AM
DmitryBubnenkov
New Contributor
I know that ArcGIS for Server for workgroup can work only with MSSQL Express. But is it's possible co connect with full version of MSSQL? I need to test how it would work with big DB.
Tags (2)
0 Kudos
10 Replies
DmitryBubnenkov
New Contributor
Thanks! I will reread docs. But if I will storage rasters in raster mosaic in FS should I use SQL for storage metadate? I understand that I can put some meta-date in raster mosaic, but in our case we will have next meta date:
-date
-time
-satellite type
-status (already loaded/processed)

This meta-date I will take from another DB and some of them from text files. By this meta-date we will plan to do query from web-portal. For my regret I have not enough experience to create good architecture. Could you explain me best way to do it's in my situation.

Every images would be 100-150 MB size in JPG\JP2 format. Every day we will plan to load in 10-20 images.

Also could you explain what data usually storage in SQL if biggest part (raster data) are usually storage in FS.
0 Kudos