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 - 2005-02-18 : 08:32:13
|
| Niladri writes "Hi, I want to transfer some tables and datas from oracle to sql server.But I don't know how to do it.Because I didn't do it before.I have to do this from SQL Server.Can anyone tells me what are the steps should I follow?Try to give solution asap.It' very urgent!!!!Thanks & RegardsNiladri" |
|
|
rockmoose
SQL Natt Alfen
3279 Posts |
Posted - 2005-02-18 : 11:58:17
|
| Option 1. Export the data from oracle to csv textfiles, then inport the files into sql server.Option 2. Install Oracle Client or Oracle Instant Client on the sql server machine and create an odbc link to oracle from sql server,then import the data using dts+odbc or link the oracle server (linked server)rockmoose |
 |
|
|
|
|
|
How to transfar Oracle data to SQL Server