topic Re: Create SDE Layer as versioned and editable in Data Management Questions

Create SDE Layer as versioned and editable

SabitaTripathi — Thu, 15 Sep 2011 18:19:45 GMT

I am using the direct connection to connect to the Arcsde (Sqlserver 2008) database. I created a spatial table and registered it as a layer using sde command. Now, I want to create service that will allow us to edit the layer in database (Feature Access Service). But I keep getting an error and on the desktop when I try to edit the layer it prompts a message "layer is not editable and it's not versioned". See the attachment.

So, the question is:
a) How do I register layer as versioned? It failed with sde -o register ...-V command
b) How do I create a layer that's editable? Note: I have already added ArcGISSOC account in sql server and grated a read/write permission.

Thanks,
Sabita

Re: Create SDE Layer as versioned and editable

BrentPierce — Fri, 16 Sep 2011 14:26:44 GMT

Sabita,

If you Open the Geodatabase in ArcCatalog you should be able to right click on the feature class or table in question and select "register as versioned". Once the class is versioned you should be able to start a versioned edit session on the class in desktop.

Hope this helps,
-Brent

Re: Create SDE Layer as versioned and editable

SabitaTripathi — Fri, 16 Sep 2011 16:29:04 GMT

Brent,

We don't have ArcEditor license therefore we can't use ArcCatalog to register as versioned. Can it be done using the ArcSDE layer command?

Sabita

Re: Create SDE Layer as versioned and editable

VinceAngelo — Fri, 16 Sep 2011 17:23:09 GMT

There are no ArcSDE command-line utilities which change anything managed by ArcObjects
(geodatabases are implemented on top of ArcSDE functionality).

- V

Re: Create SDE Layer as versioned and editable

SabitaTripathi — Fri, 16 Sep 2011 19:07:25 GMT

vangelo, Thanks for the reply!

So, are you saying we must have a ArcEditor license to make a spatial data versioned and editable? Do we need just the ArcEditor or ArcInfo as well (note that we just have Arcview license currently)?

Is there any other way to create this layer without having to use ArcEditor?

Thanks,
Sabita

Re: Create SDE Layer as versioned and editable

VinceAngelo — Fri, 16 Sep 2011 19:33:56 GMT

It helps to keep the terminology straight:
+ ArcSDE operates with 'tables' and 'layers'
+ ArcGIS operates with 'feature classes'

Only ArcGIS can register a new feature class in an ArcSDE geodatabase for editing with ArcGIS
(and only with the ArcEditor or ArcInfo license levels).

If you are using ArcGIS 10, you don't need to use ArcSDE to access tables with GEOMETRY/
GEOGRAPHY columns -- instead you can use query layers.

- V