在生产中测试部署的方法？

I've to implement many changes in the production database, from create new tables to alter some procedures and constraints. The implementation in production is made manually by a third-vendor. I've to send them a file for every script. I'm fear that the implement make some error or anything happens. But as I've to deploy in stage the same script that in production, I've to make a good post-verification script before deploy in other environment.I've to implement many changes in the productio