How to test all environment configurations for DB scripts in lower environments

I need to figure out how to test all environment configurations in lower environments before going to production env.

Sometimes, my db scripts work fine in dev and test but then when I get to prod, i start seeing some issues. So is there a way to test the DB configuration file for all environments (dev, test, preprod, prod, etc) prior to getting to PROD?