iis 7 - ASP.Net MVC SQLExpress Production Environment Update Scenario -

New to deploy an ASP.Net MVC web application with scllexpress in the App_Data folder, how do I handle database updates after that I am in live and in use

Here are my scenarios and some questions:

I have an ASP.NET MVC 2 web app w / scllexpress database: [myappData.mdf, Aspnetdb.mdf]. I was planning to publish it with the database included in the App_Data folder on the production server.

Question 1

When my site is in use and users have added new data to the database and I've added some new features, Database joints are required, how do I publish new database files while keeping all the data added to the user in the database?

Question 2

In addition to this, once I started debugging my app locally, I did not add it to SQL Management Studio. Can I get an error? So once it goes live on the production server and a user is having trouble, can not I browse through the database using SQL Management Studio?

Question 3

Right now I'm connecting with DB with the following web .config string, is there a problem in any such production environment, including Scllexpress Will be installed ?:

  & lt; Add name = "MyAppDataEntities" connectionString = "metadata = res: //*/Models.MyData_DB.csdl | res: //*/Models.MyData_DB.ssdl | res: //*/Models.MyData_DB.msl; Provider = System .Data SqlClient; Provider Connection String = & amp; quot; Data Source =. \ SQLEXPRESS; AttachDbFilename = | DataDirectory | \ myappData.mdf; Integrated Security = TrueS; User Instance = True; MultipleActivative ResetsSets = True & amp; quot; "Provider Name = "System.Data.EntityClient" />  

Thanks for any help in getting this hang on.