Prevent accidental update of host database WebMatrix

I use WebMatrix for deployment of files and databases during development. I want to continue to use it after development for updating files on the host. I also want to synchronize my local database to the host database, but never the other way around. I am terrified of accidentally overwriting the database on the host.

How can I do what I want while safeguarding against accidental updates of the database on the host? Essentially, I am looking for a way to tell WebMatrix that the host database is read only and not to be updated.

Answers


You can link the development project to the live database. That way you can still develop the files offline while using the actual data to do it. If you link to the database WebMatrix won't attempt to update it as it will already be working with it. Yes, if you make a change for development purposes it will change it on the live site. However, if you are only developing the webpages this should not be a concern. To link to your database just go to the database workspace and click on the New Connection icon. Just remember any changes to the database in WebMatrix after that point will be immediately sent to your database.


Need Your Help

Pattern And Matcher: How to -- concatenate a pattern and a string for file search

java class amazon-s3 amazon-web-services amazon

So I'm using the AWS SDK in Java and I've created a class to download the buckets/objects that are in the S3 Server.

Triggering FancyBox from ASP.Net Codebehind

asp.net jquery fancybox

I want to use the JQuery FancyBox on an asp.net page but all the examples I have found show triggering a fancybox from anchor tag (< a >). I am not able to find an example where a fancybox is