January 28, 2010 at 1:28 pm
We have a SQL Server database that stores OLE Object in a column with an image datatype. The file can be anything supported by OLE Object. Development now wants to migrate this data to a new SQL DB for use by a new application but wants only the raw file data without the OLE Object metadata. Can this be done as part of the SSIS package that is migrating the rest of the data or do we need to create some utility to save the file to disk and then import it into the new DB?
Any thoughts or suggestions would be greatly appreciated.
Mark
January 28, 2010 at 1:43 pm
AFAIK, image or varbinary(max) are not supported by raw data files. (BTW: image data type is marked as deprecated. You should move to VARBIANRY(MAX)).
If both sides are SQL Server, you could use BCP. If not, would it be possible to move your data directly from one server to the other? If not, it should be possible to use a SQL Compact database instead of a raw data file.
Greets
Flo
January 28, 2010 at 2:42 pm
I guess I was not clear on the problem. There are OLE Objects stored in an image column.
For example a JPEG file stored as an OLE Object. The new application expects just the JPEG file and not an OLE Object. The new column type is varbinary(MAX) but that is not really relevent to the problem.
We are migrating most of the data to a new DB with a new schema. Is there any way to change an OLE Object to just the file (e.g. just the JPEG file without the OLE Object metadata) as part of the SSIS that migrates the rest of the data in the DB to the new DB.
Thanks.
Mark
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply