"Davor" <kr**@mail.inet.hr> wrote in message
news:cf**********@sunce.iskon.hr...
I have to migrate database from AIX DB2 to MS Sql Server 2000. In one
table there is field with GIF image. I have tried with "Import/Export
Data" wizard on SQL server to import that table. All other fields are
successfully migrated except for that field with gif image (I get only
"GIF89A" as value in that field on MS SQL). Also, "Import/Export Data"
wizard on SQL server "sees" that field as LONG VARCHAR???? (isn't this
supposed to be some kind of BLOB field?). I'm using DB2 ODBC driver on
SQL server to connect on DB2 server.
Which version of DB2 are you running? V7.2? V8.1?
What is the DB2 datatype of the column containing the GIF? It *should* be a
BLOB if it contains a GIF; that's the only appropriate datatype for binary
data like a GIF.
Perhaps the GIFs were never properly stored in the first place. Can your
applications read and display the GIFs properly from the DB2 table?
I played with MS SQL briefly last year but don't recall if it supports BLOBs
or what it calls the BLOB datatype. As for the Import/Export Data Wizard on
SQL Server, I've never used it and don't know how it determines the datatype
of the field. I don't know it's reputation either: solid and reliable or
buggy and unreliable. You might try asking about its reliability on a MS SQL
newsgroup; perhaps the MS SQL code needs a fixpack??
Does anybody know some other way to migrate that type of data?
If nothing else works, you could migrate everything but the GIF column, then
insert each of the GIFs one at a time via an application you write yourself.
It's not the ideal option but it *might* work.
Rhino