We are setting up a new project that will involve creating and editing of features both in-office and then later in the field (to verify assets). I would like to store the data in an ArcSDE geodatabase that we have hosted on Microsoft SQL Server, in order to take advantage of versioning and conflict detection. However, we had planned to use Field Maps on Android tablets for the field data collection portion of the project, and as far as I can tell, it's not possible to connect to your ArcSDE geodatabase in Field Maps or to sync data between Field Maps and the ArcSDE geodatabase.
Has anyone run into a similar issue before and can suggest a workflow for this? I know I could just host the data on ArcGIS Online from the beginning, and then our GIS techs could easily edit it from either ArcPro or Field Maps, but then there would be more limited capabilities in terms of versioning/detecting conflicts. I also thought about dividing up the area into sections and once a particular section is complete in-office, to export it as a separate geodatabase and then upload to AGOL for editing with Field Maps. But then we would have to combine all areas back together when the project is complete.
