We're upgrading all of our clients from version 10.2B to 11.6 and one of the processes involved is to convert the databases from ISO8859-1 to UTF-8. The process I'm currently doing is:
1. Convert version 10 DB to UTF-8
2. Binary dump version 10 DB
3. Load .bd to empty version 11 UTF-8 DB
The thing is that after the conversion to UTF-8, it requires an index rebuild which takes a while on a large database. After loading the .db files, it again requires an index rebuild.
My questions is if I skip the index rebuild after converting to UTF-8, can I still do a binary dump without any issues and simply rebuild the indexes in the version 11 DB after the load? It will be a great time-saver if this is possible without encountering any issues.
Also, is there a way to find out the database code page programmatically (I can't seem to find this in the knowledge-base)? I'm trying to streamline the process in a script and I need to prevent the dump from happening if the database hasn't been converted to UTF-8.
Thanks in advance!
1. Convert version 10 DB to UTF-8
2. Binary dump version 10 DB
3. Load .bd to empty version 11 UTF-8 DB
The thing is that after the conversion to UTF-8, it requires an index rebuild which takes a while on a large database. After loading the .db files, it again requires an index rebuild.
My questions is if I skip the index rebuild after converting to UTF-8, can I still do a binary dump without any issues and simply rebuild the indexes in the version 11 DB after the load? It will be a great time-saver if this is possible without encountering any issues.
Also, is there a way to find out the database code page programmatically (I can't seem to find this in the knowledge-base)? I'm trying to streamline the process in a script and I need to prevent the dump from happening if the database hasn't been converted to UTF-8.
Thanks in advance!