I have a SQL Server on a VLAN that I have read permissions to and I need a SQL Server instance on an external network to be synced. I only have read permissions and our partner won't allow us to configure replication so that's not an option. On top of all that because it's on a vlan the external SQL Server can't connect to it directly.
I think my best bet now is simply to write an application (most likely in C#) that will detect changes and push them to the external SQL Server. This approach doesn't seem ideal.
Are there any out of the box ways to do this or any tried and true methods?
Copyright Notice:Content Author:「Bishop Duperret」,Reproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/53602353/sql-server-sync-push-sql-server-changes-to-sql-server