Change of data type (BigDecimal to Double) and data loss

I have changed the datatype from BigDecimal to Double and when I run the application I found that the value in all those fields that were BigDecimal has been null. Is there any way we can keep the data migrated from BigDecimal to Double without such data loss?



If your database supports that and data types are compatible, you can write update script manually to migrate column contents.
E.g. for HSQL the script will be:
ALTER TABLE sales_foo ALTER COLUMN price double;

Studio doesn’t do this automatically.