"long raw" Data

cat_millenium · Post by **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

Alexey · Post by **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.