Need Data Migration Points(Sybase to DB2)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

pankaj_wolfhunter@yahoo.co.in - 05 Dec 2005 06:15 GMT

Greeting,
Can anyone tell me the points to keep in mind while
migrating data from Sybase to DB2 especially in case of LOB data. I
know the books available on the IBM site, but if still someone can
provide me their own specific points?

Any help will be appreciated.

TIA

Reply to this Message

graham_martin - 05 Dec 2005 10:41 GMT

> Greeting,
> Can anyone tell me the points to keep in mind while
[quoted text clipped - 5 lines]
>
> TIA

I would point you to the Migration Station, there are some good
articles on Sybase:

http://www-128.ibm.com/developerworks/ondemand/migrate/db.html

On that URL you will also find a link to a SQL Server to DB2 Migration
redbook, which I know is not Sybase, but there is a large overlap.

As for LOBS, DB2 allows LOB columns, which can be stored in LOB
Tablespaces - there are some restictions and best practices to be aware
of, all covered in the info above.
Another difference is the Case Sensitivity, DB2 is Case Sensitive, for
Data and Catalog entries (though you need to explicitly create an
object that is not uppercase).

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Reply to this Message