Subject Re: [firebird-support] MIGRATION PROBLEMS FB 1.5 Database to FB 2.1
Author Helen Borrie
At 05:47 AM 26/04/2009, you wrote:
>Hi im try to migrate a database created in FB1.5 to FB2.1 but when i did it i had some errors.
>
>1.- In a PC with FB 1.5 i create a Backup of the database
> database15.fbk
>
>2.- i copied the database15.fbk to another PC but with FB 2.1 and i
> restore like database21.fdb
>
>3.- i can see the table and triggers but when i try to access to any procedure bring a error message said
>
>SQL TEXT
>select pr.rdb$procedure_name,
>pr.rdb$procedure_source,
>pp.rdb$parameter_name,
>pp.rdb$parameter_type,
>fs.rdb$field_name,
>fs.rdb$field_type,
>fs.rdb$field_length,
>fs.rdb$field_scale,
>fs.rdb$field_sub_type,
>
>ERROR MESSAGE
>Cannot transliterate character between character sets.
>Cannot transliterate character between character sets.

You're doing OK so far! ;-)

Now would be a good time to read the Migration and Installation notes (separate book in your /doc/ subdirectory) and the instructions in Chapter 10 of the release notes, "Metadata Text Conversion", starting on p. 104 [114 if you use Search].

Furthermore, if you are indeed trying to use Fb 2.1[.0] then *abandon it* and use the Fb 2.1.2 sub-release.

./heLen