Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Unanswered: How to migrate database from 1252 code page to UTF-8

    hi all,

    just wonder is there is any way to migrate a database from any code page (e.g. 1252) to another code page (UTF-8), i am using DB2 7.2.5 under AIX 4.3.3

    in oracle we can do this by exporting the database using certain NLS_LANG directive, but i donot know how to do this in DB2

    any ideas ?
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to migrate database from 1252 code page to UTF-8

    manually create a new database in the correct codepage and then preform a restore database to populate it.

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Re: How to migrate database from 1252 code page to UTF-8

    Originally posted by sathyaram_s
    manually create a new database in the correct codepage and then preform a restore database to populate it.

    Cheers
    Sathyaram
    just wonder if i restore DB (with the old codepage) to exsisting new DB ( with the new code page), the new one will be replaced ? and then the old codepage will be used again ?
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: How to migrate database from 1252 code page to UTF-8

    As far as I understand, if a database already exists, only the data is replaced and all other characteristics (like codepage, db cfg ) are retained ....

    If the db is not present, it is created

    Cheers
    Sathyaram


    Originally posted by hanyheggy
    just wonder if i restore DB (with the old codepage) to exsisting new DB ( with the new code page), the new one will be replaced ? and then the old codepage will be used again ?
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  5. #5
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Re: How to migrate database from 1252 code page to UTF-8

    Originally posted by sathyaram_s
    As far as I understand, if a database already exists, only the data is replaced and all other characteristics (like codepage, db cfg ) are retained ....

    If the db is not present, it is created

    Cheers
    Sathyaram
    ty for yr clrification, i never done that before, so i was just asking
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  6. #6
    Join Date
    Jun 2003
    Location
    Toronto, Canada
    Posts
    5,516
    Provided Answers: 1

    Re: How to migrate database from 1252 code page to UTF-8

    Originally posted by sathyaram_s
    manually create a new database in the correct codepage and then preform a restore database to populate it.

    Cheers
    Sathyaram
    I don't think that would work. I believe you can only restore to a database with the same code page with which the backup has been created. The only choice would be to export & load data (or db2move).

  7. #7
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Re: How to migrate database from 1252 code page to UTF-8

    Originally posted by n_i
    I don't think that would work. I believe you can only restore to a database with the same code page with which the backup has been created. The only choice would be to export & load data (or db2move).
    i will try that today and findout what exactly is going on
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

Posting Permissions

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