I need to have data from multiple tables in one SQL Server database moved to another SQL Server database on a daily basis. I am looking to find the best approach to this. The SQL Servers exist on different networks. Linked servers may not be possible. I'd like to automate this as much as I can, as it will be a daily dump of info from one server to the other. Any ideas on the best approach to this? Both are SQL Server 2012 databases.