At least for me, schema comparison is more of a diagnostic tool used in scenarios where I'm troubleshooting an issue in production and need to know what total differences there are between production and development, or perhaps discover a modification that was accidentally left out of the deployment. But even in these scenarios, the solution is to get the required script from source control, and then attach that to a new production change order for deployment. I'm still not pushing delta scripts.