At some point, large projects may choose to delete many old migrations and run mix ecto.dump to generate a structure.sql file. But then how do you deploy to a new clean server or start a staging server? This post connects the dots to get a safe, repeatable, automated deployment process for setting up a database from a structure.sql file.

https://fly.io/phoenix-files/deploying-after-a-mix-ecto-dump/