CODEWITHSUNDEEP
windows-installersql-server-ce
user416
user416

Reputation: 536

How to Upgrade Setup file without deleting Compact Sql DB

I have deployed a windows setup file with compact SQL db (local database). Now I want to upgrade the setup file without deleting the existing local database.

Could anyone help me how I can proceed with this?

Upvotes: 0

Views: 110

Answers (1)

Christopher Painter
Christopher Painter

Reputation: 55581

It's hard to give you an exact answer without knowing how your current installer is authored but basically consider the following points:

1) If you are doing Major Upgrades, where is your RemoveExistingProducts scheduled? Be careful you aren't asking the installer to do a full uninstall / reinstall as you'd get the database file reinstalled.

2) Take a look at the Component element's NeverOverwrite attribute.

3) Also consider the Component element's Permenant attribute if you'd like the SDF to remain on uninstall so that subsequent reinstall will have the same data.

Upvotes: 2

Related Questions