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 |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2008-11-10 : 06:32:46
|
| I have been using a linked server to pull data from an oracle server into SQL server 2000. The problem comes when trying to cancel the job as it continues to run on the oracle box. What other options are there for successfully transferring data efficiently? Any tools perhaps that would help? Im basically looking at pulling some quite complex queries on a daily basis over a number of hours? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
jtwork
Yak Posting Veteran
82 Posts |
Posted - 2008-11-10 : 09:17:39
|
| Thanks for your response. We are running SQL 2000 and im assuming the import/export wizard is a 2005 upgrade feature?Would using OPENROWSET break the connection on the oracle box if we cancelled the pull of data? only it doesnt seem to via a linked server? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-10 : 09:23:08
|
quote:
Originally posted by jtwork
Thanks for your response. We are running SQL 2000 and im assuming the import/export wizard is a 2005 upgrade feature?No it's not Would using OPENROWSET break the connection on the oracle box if we cancelled the pull of data? only it doesnt seem to via a linked server?
It won't . You can use DTS package to achieve that as well |
|
|
|
dbaguy
Starting Member
1 Post |
Posted - 2008-11-20 : 22:48:07
|
fastreader is one of the best tools around for migrating large amounts of data from oracle to sql server. here is a link: www.wisdomforce.comquote:
Originally posted by jtwork
I have been using a linked server to pull data from an oracle server into SQL server 2000. The problem comes when trying to cancel the job as it continues to run on the oracle box. What other options are there for successfully transferring data efficiently? Any tools perhaps that would help? Im basically looking at pulling some quite complex queries on a daily basis over a number of hours?
|
|
|
|
|
|
|
Importing data from oracle