Okay, I've created a database project in VS 2010 (running under Windows 7). I've got it all working fine, and I've spent all morning modifying tables and stored procedures, no problem.

Now I'm ready to build the deployment sql, so I tell it to build the deployment file. It does so and says it worked fine, but I can't find the deployment file anywhere. According to the properties page for the project, Deploy tab, it should create a deployment script named My_Database.sql. That file is not created anywhere on my disk drive... I searched it twice.

What I DO get in the sql/debug folder is the pre and post deployment sql files (empty), a SQLSETTINGS file, a SQLDEPLOYMENT file, a SQLCMDVARS file, a DEPLOYMANIFEST file, and a DBSCHEMA file. But since I don't see the My-Database.sql file, I have no idea how to deploy this to the target database.

Can anybody help, here?