How do i publish updates?

In VWD 2010 I created a project (ASP.NET Web Application) and have successfully deployed it with 1 click publish. I can't find the Copy Website option now, and I assume its because its a project, but how do I publish updates to pages? I've tried just publishing it, but that reverts updated production files (e.g. XML files) to the versions in the development environment. Also what about changes to a SQL database, can scripts be automatically generated to update the production database?

 

Hi,
We've added 2 webcasts for deploying with VS2010,
one for Apps: http://www.dasptv.com/avc-view.aspx?videoid=24&categoryid=0
one for Sites: http://www.dasptv.com/avc-view.aspx?videoid=25&categoryid=0

As for updates to your DB, that's a loaded question because there are many ways to do it.
If you are able to pump scripts from local to remote you are all set.
There is also an on-line DB tool you can use and you can also use page level code.
If you need more help let us know.
All the best,
Mark