I need to transfer data from a local SQL Server to one on my host where the SQL Server on the host is behind a firewall and port 1433 is closed.
I've looked at using a Service Broker and SQL Express or MS Access but both seem inefficient and can't be automated. I tried a SSIS package but without port 1433 open they won't communicate. For security reasons I'm not sure a Web service will work either.
Has anyone got any ideas on how to do this? Will a secure Web service do the trick?
View Complete Post