I use Survey123 Connect / XLSForms to create surveys hosted on our own portal. Survey data is stored in a hosted feature layer on the portal. This is great for prototyping/developing surveys. But now I want to store and sync the data in a feature class in our enterprise GDB (MS SQL Server). What I want to achieve is the same end result as creating a feature class in EGDB, publishing that as a portal service, and creating a survey from that service, but sort of in reverse, even if I have to publish the reverse-engineered feature layer as a service with sync capabilities and re-connect the survey to the published feature service. To add another complication, we allow photo attachments in our survey.
I understand that there is a Synchronize Survey Tool, but from what I have read it may be a little error-prone.
Has anyone been able to do this successfully?