views:

154

answers:

0
+2  Q: 

SQL CE deployment

Hi I have a small windows app and am trying to use SQL CE for the local datastore. I have having a couple of problems deploying it. I am using ClickOnce deployment.

First question: In the Publish properties -> Application Files I have it set to Data File(Auto), Required, Include. However it doesnt seem to be included? When I navigtate to the location that Click Once installs to its not there??

Second: Click once creats a new directory in the User\Local\Apps directory, with the app files and sdf file in (hopefully!), when I update the app and release a new version I dont want to start with a new database...all the data in the existing database will be lost?? The just doesnt seem to make sense?? What is the procedure around this?

Thx Steve