Hi,
When updating an existing database the following error message appears.
Engine Error (code = 335544351):
unsuccessful metadata update.
ALTER TABLE CURRENCY_RATE failed.
Cannot change datatype for EXCHANGE_RATE. Conversion from base type DOUBLE PRECISION to BIGINT is not supported.
SQL Error (code = -607):
This operation is not defined for system tables.
Data Modeler doesn't issue SQL commands to convert data in database.
If you have changed a table column type from BLOB to BOOLEAN, or from VARCHAR to DATETIME, or, like in your case, DOUBLE PRECISION to BIGINT, it might generate an SQL command to modify the type, but the database will likely reject it because it can't convert data from one type to another - that is what happened in your case.
You will have to manually process your data somehow and do the conversion yourself, and handle the records which incompatible values.
That is clear.
Would it be possible to show an message about possible issues when generating the SQL script?
Unfortunately Data Modeler doesn't do such specific critical analysis, it leverages it to the database.