I have object definitions stored in multiple files that constitute the contents of a git branch. How can I compare one or all of these files to the corresponding objects in a database in order to generate change scripts?
For example I add a column to a table definition which is just a create statement. How would I generate an alter statement to update the table? Normally I just push my changes and the DevOps system produces and applies all the scripts to bring the target objects into line with the VCS, but it would be extremely helpful to do this for individual objects so I can test table changes in development without waiting or applying the changes manually.
I cannot see how in the documentation.