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.
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.