You can, and I think you should, place your data and stored procedures in separate schemas. This way, migrations are only required for the data, and stored proc

You can, and I think you should, place your data and stored procedures in separate schemas. This way, migrations are only required for the data, and stored procedures can be deployed and version-controlled just like any other code.