Re: [firebase-br] Migrando 2.5 para 5.0

Marcelo Alaggio via lista <[email protected]>
Newsgroups gmane.comp.db.firebase.portuguese
Message-ID <[email protected]>
Bom dia a todos!

Também recebi a mensagem

gbak: WARNING:    function SUBSTR is not defined

durante o restore para o FB5.

A velocidade do restore no 2.5, no meu caso, era de 2h. No 5.0 caiu para 45min.

Bom trabalho a todos.


Em 07/02/2024 09:57, Rodrigo de Freitas Silva via lista escreveu:
> 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@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) ?
> ______________________________________________
> FireBase-BR (www.firebase.com.br) - Hospedado emwww.locador.com.br
> Para saber como gerenciar/excluir seu cadastro na lista, use:http://www.firebase.com.br/fb/artigo.php?id=1107
> Para consultar mensagens antigas:http://www.firebase.com.br/pesquisa_lista.html
______________________________________________
FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
Para saber como gerenciar/excluir seu cadastro na lista, use: http://www.firebase.com.br/fb/artigo.php?id=1107
Para consultar mensagens antigas: http://www.firebase.com.br/pesquisa_lista.html
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.