Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

ArcSDE 9.3.1 and MS SQL 2008 R2 In ArcCatalog the feature class is called database.DBO.fcname and when I look at the connection properties in ArcCatalog the default is called DBO.Default and the other versions are called SDE.versionname1 and SDE.versionname2. We just migrated to MS SQL 2008. I did not do the install of sde on the new server. The databases were not created new on the new server instead they were backed up and then restored to the new server from a MS SQL 2000 db and then upgraded to 2008 databases. Is the sde on SDE.versionname1 referring to the schema or the owner? Thanks.

share|improve this question

1 Answer 1

up vote 1 down vote accepted

Version names follow a owner.name convention so the SDE user owns the version named versionname1 and versionname2. Also, versions are a view of the entire database, not just a single feature class. There is not a 1:1 relationship between feature classes and versions. The ArcGIS help has additional info: Understanding Versioning

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.