Re: How to load data from an oracle database into a SQL server table
Lisa Hu <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
And this would need to be an automated process that runs each night. Does Toad have a data loader scheduler function? From: Lisa Hu <[email protected]> To: "[email protected]" <[email protected]> Sent: Thursday, November 3, 2011 1:39 PM Subject: 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, Lisa