So I have deployed a few applications to a few different clients while I'm still doing development on the project. Usually there's not a lot but there's some table structure changes to the baseline db along with some stored procedures changing/being added.
I don't want to lose any of the data in the databases that are deployed. Basically I want to write a script that will eithe move the data from the old database used by the client into the updated baseline version. Or write a script that will update the structure and stored procedures of the old database used by the client with the new baseline version.
Just looking for advice on the easiest way to do something like this.