Error on Data Transfer

[joselitux]

Hi all

Testing the newly added Data Transfer feature. Tried to transfer a table from remote server to local machine where DBeaver is installed. Created a local database named TESTING and tried that DBeaver managed the create destination table.
Get an error:

Can't alter target schema:
CREATE TABLE TESTING.mytable_local(
id int NOT NULL,
Name varchar(64) NOT NULL,
Attribute varchar(32) NOT NULL,
Value varchar(253) NOT NULL,
mime varchar(200),
PRIMARY KEY (id)
)

thanks

[Serge]

Hi,

When you transfer data to a new table DBeaver provides just very basic functionality here.
Usually most complicated part is a data type mappings. Each database engine has it's own set of data types and a huge set of possible type modifiers. Also usually it is not possible to use keyword as column name and I believe that "name", "value" may be a keyword in some database.
You may set any custom target column names and data types when configure data transfer.

I'll post a few configuration screenshots later today.
BTW What is your source and what is your target database?

[joselitux]

Worked at second try. Dunno why

Origin Database and Target Database schemas are identical