@CodyPatterson - If you decide to go with your own ETL process, then that is something that needs to be build using the ETL Tools that I described, your data model and your data is unique to you, therefore you will need to choose the ETL Tool that you are more comfortable with or ask some ETL expert to help you automate the process, you can also reach out to Esri Professional Services for assistance if you want Esri to help you with the ETL process.
* ETL stands for Extract, Transform and Load
ETL Process Tools - SQL Server T-SQL, SQL Server Integration Services, ArcGIS Model Builder, Python Arcpy, ArcGIS Data Interoperability Extension, Safe Software FME Workbench / FME Server.
SQL Server Always-On Replication is a feature of SQL Server, you can read more details in the link below about connections from ArcGIS.
Connections to highly available SQL Server databases—ArcGIS Pro | Documentation
I hope this helps.
| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov