Help please, on mdf/ldf files manipulation between dev and prod App_Data folders.
My dev folder: ...\Visual Studio 2010\Projects\WebApplication1\
My prod folder: C:\inetpub\mywebsite\
There are 4 files in [dev]\APP_Data
The VS2010 publishing process copies the 4 files to [prod]\App_Data where my website users interact with them updating data therein.
Next time I publish, the files in [prod]\App_Data get overwritten, losing all current membership and app data changed by my website users.
I tried using SQL Server Management Studio, before publishing, to export current data from [prod]\App_Data\aspnetdb.mdf and myappdb.mdf, and import to [dev]\App_Data\aspnetdb.mdf and myappdb.mdf, but that brought up a bunch of detaching/attaching issues, ending up wiping out all security permissions settings of all the related files, even though I had used SQL Server Configuration Manager to stop the SQLExpress Service beforehand.
IIS Application Pool Identity:
App_Data mdf/ldf files security permission settings:
SYSTEM: Full Control (dev/prod)
NETWORK SERVICE: Read/Write (dev/prod)
View Complete Post