3 ms·
This is a very good example of why you should be using a schema diff/comparison tool. Run your rename on a copy of your production schema, then run a diff tool
by djrobstep 5y ago
This is a very good example of why you should be using a schema diff/comparison tool.
Run your rename on a copy of your production schema, then run a diff tool to see what's actually changed - in this case it would show a view definition had changed and even autogenerate the replace statement you would need to add to fix the script.
- Ozzie_osman 5y agoWhat specific tools would you recommend for schema diffs?
- rockwotj 5y agohttps://atlasgo.io/ https://atlasgo.io/ or https://github.com/djrobstep/migra https://github.com/djrobstep/migra