I hope you can help.
I have been tasked with developing a solution to populate a sql db with data from an oracle db.
I've been trying to use a Linked Server to do this and have so far been experimenting with using OPENQUERY. For small tables it works well. But on tables with millions of rows however it is unworkably slow.
The INSERT statement I'm using seems as basic as it gets:
INSERT INTO SQL_DB.batch_transaction_analysis
(Select SELECT A
FROM OPENQUERY(ORACLE_DB,'SELECT A
Is there a better alternative to using OPENQUERY for selecting million rows of data across a linked server?
Or even a better way of writing the insert query itself that might speed things up?
Hope you can help!