Visual Studio 2008 patching without suppressing database

Posted by John on Stack Overflow See other posts from Stack Overflow or by John
Published on 2010-05-10T19:59:40Z Indexed on 2010/05/10 20:04 UTC
Read the original article Hit count: 236

Hi,

I made a program using visual c# which connects to a local .mdf sql database. I've published it using the Publish Wizard, used the files on another computer to install it and it worked fine.

However, some bugs were discovered. I've corrected the problems, published it again and tried to patch the program on the 2nd computer. After much trials and errors, fastest way to patch is to overwrite the .application file. Suprisingly, the database was also overwritten.

Question is: How do I make new version of the program and install it on the other computer without modifying the database? On developping computer, database appears as a .mdf file which can be copied, but on 2nd computer this file does not exists.

Supplementary info:
-Developping computer: Vista, using Visual Studio 2008 with Server 2005
-2nd computer: XP using microsoft express server 2005

© Stack Overflow or respective owner

Related posts about visual-studio

Related posts about database