I had a friendly but heated argument with my lead developer the other day, because our project has TSQL scripts that I code directly into SQL files, which I then run against the database. I find that when I do this, it’s easy to work out the circuit in advance without pointing or clicking, and then there is no way to forget to generate a script to control the source code, since the script generation stops being you should do it after the fact, but this is an implicit part of the process (and also leads to cleaner scripts without unnecessary errors that SQL Server Management Studio inserts into the scripts it creates).
My lead developer insists that having a manual script is a pain in the ass and that he absolutely refuses to write his scripts manually when there are great tools for doing this without coding. I noticed that copying its changes to real scripts is usually a little delayed as a result.
What are your thoughts on the pros and / or cons of doing this one way against another? Am I too tough / old school in my hand coding scripting scenarios or does he rely too much on third-party tools and lose something in the process?
source
share