Bulk Upadtion in DB

[siedevelopers]

Hi frnds,

I'm supposed to do a Bulk updation. The updation would be
carried on about 70 - 80 tables.
Is there any bulk updation facility given by SqlCe like
the one given by Oracle ?
Any suggestion or tip would be of great help.

Thanks

 

[chris-s]

AFAIK, no, there is no bulk update available in sqlce.

Depending on what you are trying to do, the RDA facilities will allow you to
create and populate a table using a simple 'select' statement directly from
an external sql server db in one step.

Chris.

 

[Pete Vickers [eMVP]]

Hi,
no experience of it at all, but this
(http://www.fitiri.com/F_Wireless_Apps2.html) was announced in the
newsgroups recently

HTH

Pete

 

[Rick Winscot]

Pete et al.

I've tried this little utility... and it does work quite well. However, it
supports only a few of the SqlCe data types (image, bvarbinary, etc are not
supported). BUT - I did a mass update of 4,000 records loaded from a web
services... and the performance was about 4 seconds. Be aware that it is
still in the beta stage...

Rick Winscot
www.zyche.com