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 |
|
putane.sanjay
Yak Posting Veteran
77 Posts |
 Posted - 2006-12-12 : 06:13:34
|
| Hi how to extract all data from oracle to sql server 2000please help me |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-12-12 : 06:19:43
|
setup a linked server.you'll have manualy transfer all tables with insert into.or you can search for a 3rd party tool that does that.Go with the flow & have fun! Else fight the flow  blog thingie: http://weblogs.sqlteam.com/mladenp |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-12 : 06:56:10
|
| Also, you can make use of1 Export/Import Wizard2 DTS3 OpenDatasourseMadhivananFailing to plan is Planning to fail |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-12-12 : 09:40:42
|
| couple of 3rd party tools out therehttp://www.google.com/search?hl=en&q=migrating+ms+sql+to+oracle |
|
|
|
|
|
|
extract data from oracle to sql server 2000