In my organization there is an installation of ArcGIS Server that is linked with an Enterprise geodatabase (PostgreSQL) in a DMZ for editing only over the web.
However, we have another installation of ArcGIS Server that is linked with an Enterprise geodatabase (SQLServer) for internal use only. The main data of the organization are stored in the internal SQLServer, and its not accessible from the web.
We use some automatization tools to copy edited data from PostgreSQL to SQLServer and vice versa, but the desynchronization is becoming a problem.
The DMZ was designed to prevent putting our data at risk. However, we know there is many organizationd that don't really care about that, and are not afraid to expose their main database through the web.
We would like to study the possibility to let ArcGIS Server to have read and write access to our main database over the web and at the same time removing the DMZ.
What could be the issues of doing such change in our organization? Is there some way to attenuate the risks if such risks exist?