How to generate metadata with IBOConsole respecting the field types?

0

I am migrating a local Firebird database to remote MySQL and used IBOConsole to generate the data for later import. But it puts all the fields inside single quotation marks, even those that are of type SMALLINT. Is there any configuration in it that allows you to change this? There are more than 26,000 records and I need to change a lot in the VARCHAR fields, I'm already trying all day, but there's always an error.

IBOConsole generates SQL as follows, but double quotation marks should not exist and only the first and last fields are VARCHAR, but all are in single quotation marks:

  

INSERT INTO "POINTS" ("TOR_CODIGO", "PON_ANO", "CLU_ORDEM",   "PON_CLASSI", "PON_PIECTS", "PON_JOGOS", "PON_VITORI", "PON_EMPATE",   "PON_DERROT", "PON_GOLPRO", "PON_GOLCON", "PON_SALDO", "PON_OBSERV",   "PON_ARTILH") VALUES ('MUNCLU', '1982', '1151', '2', '0', '1', '0',   '0', '1', '0', '2', '-2', NULL, 'Daniel');

    
asked by anonymous 26.03.2018 / 21:19

0 answers