My standard practice is to write migration scripts for new versions of the database. Then you can use the migration scripts to update the old database. This can be a lot of code to maintain so what you do is an iterative update process. IE, convert DB V1 to DB V2 then convert the newly created DB V2 to DB V3, etc. This is much easier than writing infinite migration scripts. Be cautious because you will come across database that just cannot be upgraded with 100% accuracy if you do not have a solid change control policy in place.
Need custom software developed? I do custom programming based primarily on MS tools with an emphasis on C# development and consulting. A man said to the universe: "Sir I exist!" "However," replied the universe, "The fact has not created in me A sense of obligation." --Stephen Crane