Toad World® Forums

How to load data from an oracle database into a SQL server table

Dear Toad experts,

I am an Oracle DBA who doesn’t know SQL server at all. I was asked to retrieve
data from a view that exists on Oracle database, and then import it into a SQL
server table. Seems it’s a simple task but unfortunately I have no clue how to
connect to SQL Server. Therefore, I am thinking of using Toad to accomplish this
task. How to use Toad to load data from a view on an oracle database into a SQL
server table?

Thank you in advance,


And this would need to be an automated process that runs each night. Does Toad
have a data loader scheduler function?