Editing and updating a sql table and sde featureclass

[SaadMasood]

Hi

I have a table of (point) data that is currently stored in sql server and my aim is to be able to edit and update this data by creating an SDE featureclass from it. Currently we have a series of batch files that run SDE commands to allow this process to happen however the process is long winded and requires manual user intervention.

What i would like to have, is a direct link whereby any changes being made to the point data in an arcmap or arcserver application show up in both the sql table as well as the sde featureclass, does anyone have any experience of implementing such a process? i've read that this could be possible by using the geometry keyword in sql server 2008??

many thanks
regards

Saad

[VinceAngelo]

From SQL's point of view, there is no difference between a table and a feature class.

If you have a "point table", that is the table which should contain the geometry.
If you don't want/need the power/complexity of a versioned table, don't version it.
If you want edits to the text DMS or DD real data columns to manifest a change
to the geometry, use a trigger (the same is possible from an edit to the geometry,
though doing both would be difficult).

But there isn't really any reason to do this in multiple tables -- Creating complex
links between tables only harms performance.

- V