[firebase-br] Migrando 2.5 para 5.0

Rodrigo de Freitas Silva rofresi em gmail.com
Quarta Fevereiro 7 09:57:49 -03 2024


Ola Grupo, bom dia!
Dei início ao processo de efetuar a migração da nossa base 2.5 para a 5;

Já senti o poder (velocidade) da nova versão, logo no restore do banco...

Mas vamos lá, vi que as UDFs foram descontinuadas na vr 5.
e que até existe a possibilidade de habilitar através da configuração do
firebird.conf

UdfAccess = full (mas sem sucesso),

Continuo recebendo os erros no restore;

gbak:finishing, closing, and going home
gbak:adjusting the ONLINE and FORCED WRITES flags
root em fdwrk-fb5:/home/fw/dtbs# gbak:adjusting views dbkey length
gbak:updating ownership of packages, procedures and tables
gbak:adding missing privileges
gbak:adjusting system generators
gbak: WARNING:function ADDMONTH is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function ADDDAY is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function SUBSTR is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function STRLEN is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function MOD is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function LPAD is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function ASCII_CHAR is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function SUBSTRLEN is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function RTRIM is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function FLOOR is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function ABS is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function DIV is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function RPAD is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function BIN_XOR is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function ASCII_VAL is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak: WARNING:    function BIN_AND is not defined
gbak: WARNING:    module name or entrypoint could not be found
gbak:finishing, closing, and going home

Sei que posso optar por várias maneiras, entre elas remover as procedures e
depois aplica-las novamente com suas devidas correções e ajustes, seria
essa a solucao, mas existe outra mas (simples e eficaz) ?


Mais detalhes sobre a lista de discussão lista