|
View previous topic :: View next topic
|
| Author |
Message |
Vijay.S
Warnings : 1
New User
Joined: 09 Jan 2007
Posts: 8
Location: chennai
|
|
|
|
Hi Team,
My requirement is need to store the images(which are already available in sybase datbase) to new db2 table.
Noramlly, Images will be stored in BLOB format. we need to load the same into db2 table
Does any have idea about how to migrate the sybase BLOB data in to DB2 table ?
Regards
Vijay. |
|
| Back to top |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
Vijay.S
Warnings : 1
New User
Joined: 09 Jan 2007
Posts: 8
Location: chennai
|
|
|
|
Thanks Anuj.
Ex : BLOB of Oracle might not be compatible to BLOB of DB2. we need to format the images before uploading into db2 table ( if migration is from oracle to db2)
Similarly BLOB of Sybase might or might not be comaptible to BLOB of db2. i dont have idea about this.
Do we need to do formatting before the images be uploaded in to DB2 table? and any documetns related to migration from SYBASE to DB2?
Regards,
Vijay |
|
| Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10873
Location: italy
|
|
|
|
| Quote: |
| Similarly BLOB of Sybase might or might not be comaptible to BLOB of db2. |
a BLOB is a BLOB ==> Binary Large OBject the content is a sequence of bits, and as such it is relevant only to the application dealing with it,
it will be completely irrelevant to the DBMS
thing might be different for a CLOB ( Char large object ), codepages,utf, and so on |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
| Back to top |
|
|
|
|
