Can SQL Data Compare work with a disconnected network?
The complication is there is no direct connection between them, and I can only transfer text files, specifically SQL, between the two networks.
My simplistic approach would be on the source network run a comparison between the current database versus the backup from the previous night to generate SQL with all the changes. Transfer the SQL to the other network. Apply the change SQL to the target database.
Could SQL Data Compare handle this?