Create relate between FC and Table in SQL Server databases

86
1
05-30-2019 11:54 AM
Highlighted
Occasional Contributor III

Hello everyone,

Is there a way to create a relationship  between a FC in a SDE SQL Server database and a table in a r regular SQL Server database?

Do I have to copy the table in SDE to create a relationship class  -arcpy.CreateRelationshipClass_management.

Using ArcGIS Online. we would like to show utility features and their corresponding work orders records stored in a regular MS SQL database. This is a one to many relationship.  

.

Reply
0 Kudos
1 Reply
Highlighted
Occasional Contributor III

Hi Jose,

To create a geodatabase relationship class, you need to copy table to geodatabase contains feature class. Or register with geodatabase, if the table is present in the same geodatabase of feature class.

Thanks,

Biraja

Reply
0 Kudos