Is the "sdetable" command available with ArcGIS Workgroup, or only the Enterprise edition?
We have ArcGIS Server Workgroup 9.3.1 and want to update some of the feature class tables with data from another system using SQL UPDATE commands. From taking a look at the documentation, we must first create a multi-versioned view, and then run the SQL UPDATE commands against this view. The problem is that we do not have the "sdetable" command required to create the multi-versioned view. We think that these command line tools may be available only in the Enterprise edition.
Is there another way that we can perform basic data updates with SQL commands in the Workgroup Edition? I understand that the correct way to do this is not by editing the default version directly.
EDIT:
Our data is versioned for different uses, including some field applications. We were planning on creating a "sql-updates" version just for making updates to attributes in a feature class. If I use SQL UPDATE commands to update this version, my concern is that the changes will not get replicated to the other versions, or the data could become corrupt. This seems like it would be bypassing delta table entries.
From what I have read, we should use "sdetable" to create a multiversioned view, and then use stored procedures create_version, set_current_version, edit_version (1 – start session), run my updates, edit_version (2 – close session), and finally delete_version (after reconciled). I see these stored procedures in the database, but can't do the first step of creating the multiversioned view. Maybe it would be possible to perform these steps on the "sql-updates" version without creating the view.
EDIT 2:
Since the original question has been answered, I opened a new question:
How can we use SQL to update feature class attributes in a versioned geodatabase in ArcGIS Workgroup
Best Answer
I believe you are correct. The commands you need are in the enterprise edition.
See this link for ver 10 but still applies to 9.3.1 I beleive.
That said you might try or read about the GDBT for 9.3x.
I don't remember if it had tools to create views but I do remember having some tools for version management.
GDBT tool set.