Re: copying data oracle2sql

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

openquery is not designed to move large amount of data.
the import/export wizard use the bulk insert feature of SQL Server which result on the highest performance you can for a loading.

"Seems dts import/export wizzard doesn't use rollback segment?"
what do you mean by this?
you can import data in 1 transaction or multiple transactions

"Ramunas Balukonis" <ramblk2@xxxxxxxxxxx> wrote in message news:1174662643.833343@xxxxxxxxxxxxxxxxxxxxx
Hi,
I discovered that copying data from oracle using "openquery" with linked
server is sevaral time slower that using "dtsexecui" (dts import/export
wzard). I used the same query for both methods. Does anybode has expirience
solving slowly openquery behaviour? My linked server has "allow in process"
enabled.
Seems dts import/export wizzard doesn't use rollback segment? May I could
rewrite my query?

select *
from openquery (sapr3_prd, '
select MATNR, WERKS, LGORT, LFGJA, LFMON, LABST
, UMLME ,INSME, EINME, SPEME, RETME, VKLAB
, VKUML
from sapr3.mardh
where mandt = ''600''
')

Ramunas


.

Relevant Pages

  • copying data oracle2sql
    ... I discovered that copying data from oracle using "openquery" with linked ... I used the same query for both methods. ... My linked server has "allow in process" ... Seems dts import/export wizzard doesn't use rollback segment? ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Can Data File be directly copied?
    ... can a data file be directly copied from one server to another? ... import/export most trigeers are not imported, so Data file copy, can ... If you after this reading still have specifical problems, you may want to post your detailed problem explanation, specify your Oracle environment/version and most likely you'll get kind of useful replies. ...
    (comp.databases.oracle.server)
  • Re: Can Data File be directly copied?
    ... can a data file be directly copied from one server to another? ... import/export most trigeers are not imported, so Data file copy, can ... to post your detailed problem explanation, ...
    (comp.databases.oracle.server)
  • Re: Select Into temp table
    ... I thought OPENQUERY was to access a linked server? ... I found I couldn't use the name of my server or LOCALSERVER. ... SELECT * INTO #Temp ...
    (microsoft.public.sqlserver.programming)
  • Re: Remote calling a UDF
    ... an OpenQuery or your SELECT? ... DECLARE @var VARCHAR ... > Thanks for the help Uri, ... > specific amount of data from the remote server. ...
    (microsoft.public.sqlserver.programming)