topic Attachments - Remote Database in Data Management Questions

Attachments - Remote Database

ShaunConway — Thu, 08 Sep 2011 16:00:18 GMT

Good Afternoon,

We are embarking on the migration of our GIS to version 10. At the same time, our organization is looking at implementing a citywide document management system. For that reason, we were intrigued by the new attachment feature of version 10. I just had a, most likely ridiculous, question:

Can the attachment table be stored in a separate sde database? ( I guess the underlying question there is can relationship classes be set up across databases?)

local government
soon to be arc10
sql server

Thanks,
Shaun

Re: Attachments - Remote Database

JakeSkinner — Thu, 08 Sep 2011 16:52:11 GMT

Relationship classes can only be created in the same geodatabase that contains the feature classes or tables. Therefore, the feature class, relationship class, and attachment table must reside in the same geodatabase.

Re: Attachments - Remote Database

ShaunConway — Thu, 08 Sep 2011 19:17:35 GMT

Thanks for the info Jake. That pretty much limits its ability to be utilized as an enterprise level document management solution - but still very useful.

Just a shot in the dark, but do you have any information of document management systems that integrate well with esri?

Shaun

Re: Attachments - Remote Database

BruceHarold — Fri, 09 Sep 2011 14:43:13 GMT

Hi Shaun

Our user conference proceedings and the partner search areas should give you some options:

http://www.esri.com/partners/apps/search/

Regards