Hi everyone,

My programming history has consisted primarily of GUI development using XML as the backing store. Now the time has come to move some of my projects to full fledged databases (will target SQL 2005 first with MySQL added after that) but I have a question on how to handle schema and data updates between releases.

Anyone care to share how you manage the updates of your customer's production database from one version to the next without killing their data?

Pointers to online resources would be awesome too as I've come up with very little in my search so far (probably not using the proper search terms).

Thanks and Happy Holidays!!

Michael

P.S. Frans, your product ROCKS! My software thanks you

Similar threads: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=8008 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5138 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=6065

Walaa wrote:

Similar threads: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=8008 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=5138 http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=6065

Thanks Walaa. I had heard of red-gate's tools and am planning to take the SQL Compare product out for a spin soon. Hadn't heard of DB Ghost before and am looking at that too. Holy cow on the cost! These suckers are expensive for a small-time developer like me.