How to convert SQL Table to SDE feature Class

Question

Is there is a way to Programmatically create & update ARCSDE feature class from SQL table, the SQL Table contains Latitute & Longitude values in seprate column and the data type is float . Iam using ArcSDE 10 and SQL Server 2012 enterprices.

VinceAngelo · Answer

In order to determine the supported databases for each version, you go to support.esri.com,
select the System Requirements under Knowledge Base, then explode the ArcGIS Server
list on the resulting page.  The navigation for 10.0 database requirements is two additional
steps over 10.1 (follow the "10" link and open Geodatabases and ArcSDE System Requirements
below ArcGIS Server -- this does not list SQL-Server 2012). The 10.1 links all include
 "See technical article 40559 for more information" which states  ArcGIS 10.1 supports SQL Server 2012 Express, Standard, and Enterprise  editions. ArcGIS 10.1 leverages the same SQL Server capabilities that it  does for SQL Server 2008 R2. Support for some additional SQL Server  2012 features will appear in later releases of ArcGIS.

You don't really even need ArcSDE to solve this problem, since a simple query layer will suffice
(though you'll need to look elsewhere for how to use the SQL-Server native GEOMETRY type 
with either a trigger or alteration of the previous load script to poulate points).  If you do want to 
use ArcSDE in a supported configuration, then there are a number of possible methodologies
to spatially enable the table and populate the geometry values, but they're mostly Rube Golberg 
affairs involving multiple maintenance steps, which all lead back to native geometry with either 
triggers or alteration of the previous load script to include a geometry column.

It's also important to understand that nothing is ever stored "in SDE" (even without the distraction
that the product name changed years ago).  ArcSDE is only the enabling technology to access
objects in the database -- there is no conversion necessary from a table to a feature class,
because a feature class is a table.

- V

SathishkumarJaganathan · Answer

Angelo, thank you for your Reply.

Can you please elabrate this SQL-Server 2012 is NOT supported by ArcGIS Server 10.0 (in fact, it won't be fully supported until a service pack of 10.1) and...
We are having the set of incident location detail in SQL Table which contains lat, lang information as mentioned in previous post, my task is to Convert (First time) all these data into SDE feature class , and every day we have to update this feature class from the SQL table (since, the data is directly stored into SQL Table not in SDE) without any human interaction, then i have to refresh the published map service and do the analysis on the updated layer.. I need the basic idea and some guidelines to do this.

VinceAngelo · Answer

Certainly, though the definition of 'programmatically' could drastically change your procedure.

- V

Note - I need to amend this response:

SQL-Server 2012 is NOT supported by ArcGIS Server 10.0 (in fact, it won't be fully supported until a service
pack of 10.1), so "certainly" isn't certain, though there still are a number of potential configuration paths
to something close to what you may want.

It would still help if you could define what it is that you are looking to accomplish (use application X to
produce output Y), rather than simply prescribe the methods you require to to get there.

- V