Deployment Script Generator Does Not Handle Type Changes

bugs
1

Deployment script generator does not create the correct script if a field type is changed. This is how to reproduce the issue:

  • Open the demo model (or any other model).
  • Change data type of any field in any entity
  • Save the changes
  • Open the deployment script generator
  • Switch the Filter to Different
  • Select the changed field now shown in the list and click Add to Deployment
  • The generated deployment script will be
ALTER TABLE "NewTable" ALTER COLUMN "Name"  DROP NOT NULL

So the script does not change the data type, it changes nullability which is not different between the model and the db.

2