Attachments - Remote Database

524
3
09-08-2011 09:00 AM
ShaunConway
Occasional Contributor II
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
0 Kudos
3 Replies
JakeSkinner
Esri Esteemed Contributor
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.
0 Kudos
ShaunConway
Occasional Contributor II
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
0 Kudos
BruceHarold
Esri Regular Contributor
Hi Shaun

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

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

Regards
0 Kudos