Create relate between FC and Table in SQL Server databases

Question

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.

.

BirajaNayak · Answer

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