[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