I just installed ArcGIS for Server Workgroup and have Standard Desktop. I learned how to import data into the SQL database, but i want to emulate a File GDB with data sets and relations. I do not know how to start because it only lets me import all layers into the root space. Any suggestions where to start? Templates or white papers or other suggestions are welcome.
ArcSDE Workgroup will only work with SQL Server Express.
You can either use the SQL Server Express 2008 R2 provided along with the sde setup OR download/install any desired (supported) version of SQL Server Express from Microsoft's site and use it as well.
--------------------------
However, if you have to use SQL Server Standard edition (the SQL Server express has database size limits)......then you need an ArcSDE Enterprise license for that.
Asrujit, i believe i can end this discussion. You have been very patient and helpful! I have come a long way in educating myself on this installation. I just downloaded the June 2014 White Paper on Server Functionality Matrix and conclude what we need to do. I need to either forget the SQL, because IT says they have SQL Standard and do not want to install Express; or talk to ESRI salesperson about licensing up to Enterprise to use SQL Standard.
