Export datatype mapping defaults not appropriate about dbeaver HOT 6 OPEN

It is configurable. Please refer to our documentation for more information: https://dbeaver.com/docs/dbeaver/Data-Migration/#column-mapping

from dbeaver.

Hi,

I have used the way shown in the documents to click the configure button and then modify the target datatypes. What I am looking at is a way to edit the way datatypes are chosen. As in my example the Oracle table has LONG RAW and many NUMBER (X,X) tables. If we want to say select 100 tables for export to a SQL Server I would like the mapping to be globally edited to be NUMBER(38,0) -> NUMERIC(38,0) and LONG RAW -> VARBINARY(MAX).

I don't see any global place to change that, just the individual table editing of columns, which may be many columns in a table over many tables.

Is that something that requires using the commercial version to get or is there some other way to do it I am totally missing(very possible).

Thanks for your time.

from dbeaver.

Currently there is no global mapping

from dbeaver.

Thanks. How is the target DDL created? Are those determined by the DB drivers used? There must be something that tells DBeaver to map a certain datatype to the datatype on the destination that it uses to generate the create table DDL.

Thanks again.

from dbeaver.

We rely on the data kind, name and length to map the data types.

from dbeaver.

Thank you for the idea!
We decided to add the ability to define a mapping on data transfer for certain data types for certain databases.

from dbeaver.