?
Thanks for the confirmation. I just tested this technique, and it worked really well, actually. I'm going to use the following naming convention:
DEV SQL Server (the actual DEV database)
TEST to DEV SQL Server (the TEST database available to the DEV BuildMaster environment)
PROD to DEV SQL Server (the PROD database available to the DEV BuildMaster environment)
I was concerned that BuildMaster would want to re-initialize the database, but it didn't. In fact, during the next build in DEV, BuildMaster correctly backed up my PROD db and restored to DEV and then determined that my SQL Change Script had never been run (since the BuildMaster execution table is also restored). This is how I expect and want it to behave.
Thanks again for the VERY FAST response!
Matthew