Moving BLOB data from SQLCE2 to SQL Server

[Guest]

Is it possible to move BLOB data from SQLCE2 DB to SQL Server 2000 DB programmatically without using replication? Thank you in advance.

 

[Alex Feinman [MVP]]

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

Is it possible to move BLOB data from SQLCE2 DB to SQL Server 2000 DB

programmatically without using replication? Thank you in advance.

 

[Chris Craft]

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/

Is it possible to move BLOB data from SQLCE2 DB to SQL Server 2000 DB

programmatically without using replication? Thank you in advance.

 

[Chris Craft]

Sorry guys misread the question.

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