We are working on one legacy framework and it is continuously evolving.
Problem 1 : If somebody want to run the application with latest code then he/she spend lots of time in doing so (like somebody forgets to commit code or commits partial code).
Solution : We started using Jenkins and integrated it with our SVN repository with it. So now we always have working code. We thought, now anyone(especially new developer) can get started with application in very short time.
Problem 2 : Soon we discovered that its not code but changes in database(like adding new table or altering existing table or changes in database bootstrap script) that takes developers time.
My question is, how can I deploy code changes (which currently, I am able to do) as well as database changes (which I don't know how can be done) to some test server using some automation tool like Jenkins.