Tagged Questions

1
vote
0answers
38 views

ArcGIS 10.1 SDE database schema other than SDE or DBO

Just wondering if it's possible to apply a schema other than SDE or DBO to SDE feature or raster tables stored in an enterprise database on MS SQL Server 2008 R2. I have got a new customise schema ...
0
votes
1answer
170 views

How to import ArcGIS 10.1 File geodatabse to MS SQL Server 2012

Hello I´d like to import my File Geodatabase from ArcGIS 10.1 into MS SQL Server 2012. I´ve never do it before, so I expect to do the import same way as import data from excel table. Problem is ...
0
votes
1answer
54 views

Is it possible to create an “Empty” version of an SDE database?

Is it possible to create an "Empty" version of an SDE database? I have a large default SDE database that I would like to create an empty version for a new project. By "Empty" version I am referring ...
3
votes
1answer
123 views

Has anyone been successful using the CAST function in ArcMap 10 with ArcSDE 10

I would like to use the CAST function in the definition query property of a layer and/or in the label class sql query window. This was the most promising link that I've found, including the two links ...
2
votes
0answers
213 views

How to get WKT from SHAPE column in the ArcSDE geodatabase?

I have an ArcSDE geodatabase running on top of SQL Server 2008. A table for a feature layer was added from ArcCatalog. The SHAPE column is a type of int which was automatically converted from ...
2
votes
1answer
453 views

create SDE feature class in MS SQL Server

Unfortunately I am totally dumb when it comes to programming, and very new to databases (mainly because I studied geography), so : I have a Microsoft SQL Database Server, and a ArcSDE geodatabase. I ...
1
vote
1answer
1k views

ArcSDE error: “Maximum number of connections to instance exceeded ”

I have an ArcSDE error: " *Failed to connect to database. Maximum number of connections to instance exceeded " Did what ESRI recommended :" Check the value set for the CONNECTIONS parameter in ...
1
vote
1answer
202 views

How to run “sdetable register” command in SQL Server?

I was planning to run "sdetable register" command to register a particular field as OID for an non-spatial table already created in a SDE database. I am with SQL Server 2008 R2. I tried to run the ...
1
vote
1answer
182 views

How to convert int type OBJECTID to ObjectID type recognised by ArcSDE?

I have an ordinary table with OBJECTID column (type of int) in a MS SQL Server 2008 R2 instance. I need to store it in an ArcSDE geodatabase instance running on top of the SQL Server. The thing is how ...
3
votes
1answer
640 views

Adding rows of data to a non-spatial table in ArcMap with a SDE SQL Server for Metadata purposes

I'm attempting to use several non-spatial tables to better organize the large set of feature classes I continually add to a SDE Geodatabase (SQL Server Express). So I have several tables setup and ...
3
votes
1answer
852 views

Can spatial data in Oracle be imported into SQL server?

Oracle supports spatial data and so does SQL Server. What are the things to consider if we have to migrate spatial data from Oracle to SQL Server? Are there any features in Oracle that are not there ...