Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2006
    Location
    Pune , India
    Posts
    433

    Unanswered: Sybase SQL Migration to DB2

    hi All,

    i have to migrate sql queries / SP for a application from sybase to db2 and i was told that db2 migration toolkit cant be used.

    Sybase is new to me and i found Joins/Update/Delete statements quite different from DB2 (Handling multiple tables).

    Can someone please point me to some good tutorials for sql migration for same
    Rahul Singh
    Certified DB2 9 DBA / Application Developer

  2. #2
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    You might want to start from here.

    Migrate Now! to DB2
    http://www-01.ibm.com/software/data/db2/migration/

    Porting from Oracle or Sybase? Use these sample UDFs
    Sample UDFs for Migration
    http://www.ibm.com/developerworks/db...dfs/index.html

    Migration Toolkit Overview
    Migrate Now!
    http://www-01.ibm.com/software/data/db2/migration/mtk/

  3. #3
    Join Date
    Feb 2008
    Location
    Japan
    Posts
    3,483
    You can see
    "Comparison Table ---> (Another Window)"
    "Comparison of functions"(including Sybase R11.0, Oracle 9.2, DB2 UDB for LUW V8.1) in
    Sample UDFs for Migration
    http://www.ibm.com/developerworks/db...dfs/index.html

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •