"long raw" Data

"long raw" Data

Postby cat_millenium » Sat 24 Feb 2007 11:58

Hi,

I have one table in oracle and one on sqlce

create table ora
(i as integer,
dat as long raw)

and
create table sqlce
(i as integer,
dat as image)

Now I want to copy the records from ora into sqlce.
What is the best way to do this?

Regards,

cat_millenium
cat_millenium
 
Posts: 5
Joined: Thu 08 Feb 2007 08:47

Postby Alexey » Mon 26 Feb 2007 09:17

There is nothing quicker in Oracle then "select * from ora" with reader. In SqlCe there is also no acceleration technique we know. Just inserting in a loop.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for Oracle