The task is to find a way to pull a huge table with 80 million lines from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting with access being restricted to Cisco VPN. Split tunneling is not allowed! (This is my problem: This means a machine that is connected via the VPN has no internet access, a physical access to control the machine is therefore necessary.)
Simple converter tools I have tried suffer from a latency issue (84MB in 8 hours pulled), apparently they go line by line and the latency kills me.
The table itself is extremely simple (no no views, storage produceres, no indexes, identities etc.).
The task here is to find a workable way that allows the extraction of the table within hours, not month. And to explain the procedure and configuration clearly. Given data security issues the solution would then be implemented by myself.
3 freelancers are bidding on average $300 for this job
Hi, I would like to use my long experience of databases technologies to see if my solutions can work, I have few approaches both from SQL and Oracle end. Please let me know how we can move forward. thanks.