Which way to update data and schema on the test server?

Question

SQL

Greetings.
There is a "combat" base on mssql 2008 for 50GB, on a remote server with vpn access.
I need a "test" database, on mssql 2014, on a local server.
The combat database is quite loaded, but there are few changes (several tens of thousands of rows per day), and almost all of them pull triggers (which is bad). And I do not need a complete database, because. there several hundreds of tables are generated and deleted, all of them are not necessary to me.
I need a selective number of tables (with the ability to expand the list), as well as the data in them about 1-2-3 times a day, more often it is not necessary. You don't need to send anything back.
Previously, I just copied the backup of the database. But pulling 50GB over vpn at a speed of 3-4Mbps is not very good, sometimes data is needed within an hour,
What strategy would you recommend?
Replication? Pull data manually? Scripts?
Thanks for answers!
PS I forgot to say that there is no place for a test database on the remote server.

Answer 1

It is necessary to deal with bcp, at first glance an excellent tool but requiring non-surface study.
I decided to do everything manually with scripts.

Answer 2

1. Make a test database on a remote server or on a server in the same network, so as not to carry 50 GB of backups each time over VPN. Work with the test database, you may have to transfer the same to a remote computer.
2. You can export the necessary tables to external files, then you can pack the files, etc. See bcp .