Devart Forums

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

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.