topic Re: Can i get help setting up data structure in SQL? in ArcGIS Enterprise Questions

Can i get help setting up data structure in SQL?

JimDahl — Tue, 05 Aug 2014 14:45:22 GMT

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.

Jim

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Tue, 05 Aug 2014 16:51:35 GMT

If you already have the SQL Server sde workgroup geodatabase setup and ready for use, you can simply Copy/Paste or use XML Export/Import to transfer all the data from the File gdb to this sde gdb. This will bring over all the datasets, relationship classes, etc as it is.

Re: Can i get help setting up data structure in SQL?

JimDahl — Tue, 05 Aug 2014 17:43:17 GMT

How do I set up an SQL Server sde workgroup geodatabase?

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Tue, 05 Aug 2014 18:05:15 GMT

Jim Dahl wrote:

I learned how to import data into the SQL database

Were you loading data into a simple SQL Server database?

ArcGIS Server Workgroup Microsoft SQL Server Express installation‌

Re: Can i get help setting up data structure in SQL?

JimDahl — Tue, 05 Aug 2014 18:17:23 GMT

Thanks for the link. How do i find the Authorization file? How do i know if it was a simple SQL server database? IT set it up. Sounds like i need to contact our sales rep or tech support?

Jim

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Tue, 05 Aug 2014 18:47:47 GMT

You can download the authorization file from the My ESRI website (Esri Accounts). You can also use the KEYCODES file generated after authorizing ArcGIS for Server Workgroup. Its usually located on the below location on the ArcGIS Server machine:

C:\Program Files\ESRI\License10.x\sysgen\keycodes

There are multiple ways of confirming if its a database or a geodatabase. For a quick confirmation:

this is how it comes up in a simple sql server database:

and this is how it shows up in an sde geodatabase:

Re: Can i get help setting up data structure in SQL?

JimDahl — Tue, 05 Aug 2014 19:08:41 GMT

thanks, this is making more sense.

It was a simple.
I want an SDE GDB.
I have authorizations from the website.
Do i want to install on Desktop ArcGIS Desktop or ArcGIS Engine Microsoft SQL Server Express installation guide‌
Or on the Server ArcGIS Server Workgroup Microsoft SQL Server Express installation‌
I have Standard on both Server and Desktop, server is Workgroup.

Thanks,

Jim

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Tue, 05 Aug 2014 19:13:06 GMT

Both the links state the same thing. Its just that this one is more descriptive:

ArcGIS Server Workgroup Microsoft SQL Server Express installation‌

Run the ArcSDE for Workgroup setup on the database server

Re: Can i get help setting up data structure in SQL?

JimDahl — Tue, 05 Aug 2014 19:34:08 GMT

thanks, for clarification i need to run these points by you.

Do I need to install any on my Desktop?

ArcGIS Desktop or ArcGIS Engine Microsoft SQL Server Express installation guide

This is what you want installed on the SQL Server?ArcGIS Server Workgroup Microsoft SQL Server Express installation

Do I need to install anything on the Server where ArcGIS for server is installed?

Jim

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Tue, 05 Aug 2014 20:02:37 GMT

Nothing on the Desktop or Server box....just run the setup for SDE Workgroup on the database server and enable the instance.

Then connect to the instance from ArcCatalog "Add database Server" and create the sde gdb

Re: Can i get help setting up data structure in SQL?

JimDahl — Wed, 06 Aug 2014 00:41:34 GMT

Thanks

Asrujit,

I think i finally found the download on My ESRI and might have it. I will know tomorrow. if if works i will give Kudos and finish up this thread.

Jim

Re: Can i get help setting up data structure in SQL?

JimDahl — Thu, 07 Aug 2014 15:20:32 GMT

Asrujit, my IT person says we have SQL Server Standard. This download appears to be for Express. is there another download we need to get?

Jim

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Thu, 07 Aug 2014 15:26:03 GMT

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.

Re: Can i get help setting up data structure in SQL?

JimDahl — Thu, 07 Aug 2014 15:39:42 GMT

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.

Jim

Re: Can i get help setting up data structure in SQL?

AsrujitSengupta — Thu, 07 Aug 2014 15:44:29 GMT

Glad that I could help in any manner. Feel free to let us know if you need any more information.