Moving BLOB data from SQLCE2 to SQL Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to move BLOB data from SQLCE2 DB to SQL Server 2000 DB programmatically without using replication? Thank you in advance.
 
Create a web service with a method that takes among other parameters a byte
array. On the service side inside that method write the array into the SQL
server. On the device side extract the record from SQL CE and submit it to
web service method

Lisa Smith said:
Is it possible to move BLOB data from SQLCE2 DB to SQL Server 2000 DB
programmatically without using replication? Thank you in advance.
 
Have you looked at the following:

Demonstrates storing bitmap data in an Image filed in SQL Ce database,
retrieving this data and loading it into a PictureBox.
http://www.opennetcf.org/Forums/topic.asp?TOPIC_ID=932

There is a certain elegance to using BLOB for images, but many people frown
on the practice. I tend to avoid it, but see its uses.

Thanks,
Chris Craft
http://www.cjcraft.com/

Lisa Smith said:
Is it possible to move BLOB data from SQLCE2 DB to SQL Server 2000 DB
programmatically without using replication? Thank you in advance.
 
Back
Top