469,654 Members | 1,807 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,654 developers. It's quick & easy.

Need Data Migration Points(Sybase to DB2)

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

Dec 5 '05 #1
1 1842

pa***************@yahoo.co.in wrote:
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


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

http://www-128.ibm.com/developerwork...igrate/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/

Dec 5 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Jolly Paily | last post: by
reply views Thread by Mike Bender | last post: by
2 posts views Thread by Martin Wingelaar | last post: by
1 post views Thread by Yanik Reid | last post: by
reply views Thread by Sushi | last post: by
1 post views Thread by Roy Roger58 | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.