Bulk Upadtion in DB

  • Thread starter Thread starter siedevelopers
  • Start date Start date
S

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
 
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 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
 
Back
Top