Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vijaya
Starting Member
1 Post |
 Posted - 2002-10-02 : 05:30:01
|
| Hi, i am trying to transfer data from SQL server to Oracle and Oracle to SQL server.For this i am using 'bcp' (a command line utility which comes with sql server) to export data to a file.This will copy only the data to the file without any colomn names. How can i import the data from that file to Oracle8i database.Is there any common utility that we can use for data transferring other than DTS. After exporting the data i need to execute some sql statements ..that's why i am using a command line utitlity so that i can do using a batch file. Thanks in advance,VijayaB Vijaya Reddy |
|
|
YellowBug
Aged Yak Warrior
616 Posts |
Posted - 2002-10-02 : 06:10:21
|
| You can use SQL*Loader (sqlldr)It is similiar to bcp (in SQL Server and Sybase) and used for moving data from external files into the Oracle database. |
 |
|
|
|
|
|
Import/Export data from SQL Server to Oracle