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 !