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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-02-20 : 09:15:36
|
| Sanjeev writes "Q. I have legacy database oracle 7.1 (16 bit). I want to port the data from Oracle 7.1 to SQL 7.0(32 bit), How can I ?An early response will be aprreciated.regardsSanjeev verma" |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-20 : 11:43:34
|
| I would try DTS first. I know there is an Oracle driver, but I am unsure which versions of Oracle it works for.If that doesn't work, i'm sure Oracle has some way of exportin the data to text. Do that, then DTS or BCP it in.HTH-Chad |
 |
|
|
|
|
|
SQl Server --- BCP in