Re: [firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?
loris.lu...@gmail.com [firebird-support] wrote: I need your help and/or suggestions to solve a (maybe uncommon) task. I searched a lot on the web and I had some success using a tool called fbclone but this is definitely not a solution (due to extreme slowness of the conversion, many days, something must be wrong with this software) I have a large Firebird 2.5 DB (a couple of tables have few millions records) to convert from WIN1251 charset to UTF8 charset. Is there a way to do efficiently this kind of conversion? (preferably not using a intermediate text sql dump, that would not applicable because the size of the DB). I'm using Firebird on a linux machine, and I really like to do the job using a bash script, but I can fallback also using a remote Windows pc. Thanks for any suggestions. Best regards. Hej, maybe this one is of help: http://www.ibphoenix.com/resources/documents/design/doc_150 hth, Marcus
Re: [firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?
Em 30/5/2014 04:26, loris.lu...@gmail.com [firebird-support] escreveu: I need your help and/or suggestions to solve a (maybe uncommon) task. I searched a lot on the web and I had some success using a tool called fbclone but this is definitely not a solution (due to extreme slowness of the conversion, many days, something must be wrong with this software) I have a large Firebird 2.5 DB (a couple of tables have few millions records) to convert from WIN1251 charset to UTF8 charset. Is there a way to do efficiently this kind of conversion? (preferably not using a intermediate text sql dump, that would not applicable because the size of the DB). I'm using Firebird on a linux machine, and I really like to do the job using a bash script, but I can fallback also using a remote Windows pc. Thanks for any suggestions. Best regards. I don't know if there is a faster way... But this one would be a secure and very easy way: 1.) Extract metadata from the source database (isql -x) 2.) Change the definition of the domains and/or fields to the desired charset 3.) Create a new database with the corrected script 4.) Use IBDatapump (or any other datapump tool) to transfer the data I don't know the size of your database, but I doubt it will take days to transfer it. To speed up the process, turn forced writes off, try to keep the source/destination database on diferent disks and use local/embedded connection see you !
[firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?
I need your help and/or suggestions to solve a (maybe uncommon) task. I searched a lot on the web and I had some success using a tool called fbclone but this is definitely not a solution (due to extreme slowness of the conversion, many days, something must be wrong with this software) I have a large Firebird 2.5 DB (a couple of tables have few millions records) to convert from WIN1251 charset to UTF8 charset. Is there a way to do efficiently this kind of conversion? (preferably not using a intermediate text sql dump, that would not applicable because the size of the DB). I'm using Firebird on a linux machine, and I really like to do the job using a bash script, but I can fallback also using a remote Windows pc. Thanks for any suggestions. Best regards.