We bought SQL Doc so that we can document "version 2" of our production database.
SQL Doc points to a copy of the database on my local SQL Server. Once a week or so we backup/restore from production to my local machine and run some scripts that bring the schema up to v2.
I spent about 10 hours adding in all of last week's changes, brought over the latest copy of the database to my local server, ran the scripts, and now all my work is gone!
This is the second time this happens. How do I save my work and prevent this from happening again?