migrate and deploy are the two commands in P{risma that you should be using when working with production databases and making Breaking change, that may not be easy to reverse, if you have no backup.
migrate
Migrate command creates migration files with SQL that tell the database how to make amendments to the database to migrate data successfully and update the model. Most of the time, the migration files will be correct, but sometimes you may have to make some amendments.
deploy
Deploy command is used to deploy the migration files and apply it to a database. This should probably happen while running your release Pipelines.
https://www.prisma.io/docs/orm/prisma-migrate/understanding-prisma-migrate