Hey guys,
I was wondering what would be the best way to deploy my product?

I really like the setup deployment, but i heard that its hard to issue automatic updates? And even if the user downloads a updated version, it does a clean install which is bad since it wil replace the old db, with new db .. (a mdf file).

Clickonce is great I hear because of the updating capability. But how does it look on the user end? Is it just like a "setup" that luanches ? and does it install in program files? with shortcuts in desktop and startmenu?


I'd like the capability of a "setup" type, with automatic updates that does not delete my old db..