| |
|
If this is your first visit, be sure to check out the FAQ by clicking the link above.
You may have to register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
|
 |
03-02-04, 04:50
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Egypt
Posts: 61
|
|
|
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
|
|
03-02-04, 06:55
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
|
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.
|
|
03-02-04, 08:00
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Egypt
Posts: 61
|
|
|
Re: How to migrate database from 1252 code page to UTF-8
|
|
Quote:
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
|
|
03-02-04, 08:31
|
|
Super Moderator
|
|
Join Date: Aug 2001
Location: UK
Posts: 4,534
|
|
|
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
Quote:
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.
|
|
03-02-04, 08:47
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Egypt
Posts: 61
|
|
|
Re: How to migrate database from 1252 code page to UTF-8
Quote:
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
|
|
03-02-04, 09:28
|
|
:-)
|
|
Join Date: Jun 2003
Location: Toronto, Canada
Posts: 4,449
|
|
|
Re: How to migrate database from 1252 code page to UTF-8
Quote:
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).
|
|
03-02-04, 23:14
|
|
Registered User
|
|
Join Date: Jan 2004
Location: Egypt
Posts: 61
|
|
|
Re: How to migrate database from 1252 code page to UTF-8
Quote:
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
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
dBforums
>
How to migrate database from 1252 code page to UTF-8
