Hello,

this is my problem:

When working in webmatrix, if I have a published site and I need to re-publish it to update the live version to my local version and I need to update the database too, I can't.

Webmatrix will say that the file is in use. Of course it's in use, 'cause IIS is running on the server, and the site is live, so it's using it's database, and it can't be overwritten.

What bugs me the most is that I haven't found any way to overcome this problem, if not by stopping my website's application pool on my server, or restarting the IIS service, but that's too much fuss!

There's got to be a simple way to update the database from webmatrix.

I usually use a SQL CE database but I can switch if SQL Server is needed.

Please, this is driving me nuts, I hope it's possible and someone will show me the way!

Thanks in advance