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-01-20 : 17:38:03
|
| Amit writes "hi!is it possible to convert data from Oracle to SQL server7.0?if yes, then what's the procedure for it?thanks and regards,Amit" |
|
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2002-01-20 : 18:08:06
|
| Yes - easily.(I'm not sure what you mean when you say convert.) But you can definitely import data from an Oracle Server into an SQL Server database using DTS, Data Transformation Services.You'll need to have Oracle Client installed on the SQL Server (if you're doing it regularly) or just on your development machine if your doing it once or twice only.You should check that you can query the Oracle DB using, say, 32-bit ODBC TEST (from Oracle). Once you've got that, just create a DTS package with an Oracle datasource and a SQL Server sink. The default transformations will be generally correct. However, you should also manually check every numeric result data type as they are often wrong.In any case, create your DTS package and if you have a problem, write back.I hope that when I die someone will say of me "That guy sure owed me a lot of money"Edited by - rrb on 01/20/2002 18:08:54 |
 |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-01-20 : 20:09:06
|
| You can also reference the data on Oracle directly if that's your preference. Look at OPENQUERY and linked servers in Books On-Line. |
|
|
|
|
|
|
Data conversion from Oracle to SQL server