Scripted daily SQL dump from Oracle 19.c to SQL Server 2016

* I have an SQL user to an Oracle 19c instance, without access to the server's operating system. * Secondly, I have an SQL user to a SQL Server 2016 instance, and a Remote Desktop user. Both servers live in different networks, and the connection between them is rather slow, let's guess it is 20 MBit per second. Now I have to get the data of 5 tables each day from Oracle to SQL Server, roughly 3 GB overall. I created the table structure in SQL Server once, so I only need INSERTs, probably preceeded with a TRUNCATE TABLE.... As a MySQL user I like to find a console tool like mysqldump, but any solution is appreciated. I tried a linked server using a syntax like INSERT INTO ... SELECT * FROM OPENQUERY(...) , but that runs in a timeout after 30 seconds, ending up in ~1000 rows on the target server. I also exported by hand via Oracle SQL developer, which took me one hour for one table, and on top I needed to edit some date/time values to make them compatible for SQL server. I could live with the slowness, if at least there was a real *automated* and *stable* way of doing it.