>I guess the best approach might depend on the size of the DB - but I still wouldn't know what to recommend :-}
>
>Best,
>Viv

I think I'll just stick with 2005 until I get that worked out. I'm a bit surprised I haven't been able to find any walk through posts on this. I find 1 click and web stuff, but not setup project / desktop stuff. So I'm going to keep this simple till I understand it better.

Here's where I'm at:

1. Added Dotfuscator command to the release post build event on the exe, Apparently this won't auto run, but it brings up the build window and you can click build. I obfuscate my exe and dlls here.

2. Added a setup project, set the prerequisites (I need the full 4.0 .net version and SQL2005) (I get a warning about the 2.0 .net prerequisite not being selected, but I think I know how to fix that.)

3. Select the obfuscated assemblies and add them to the application folder.

***

Now I have a setup project that installs fine on the target machine, and has the necessary programs installed.

What's the best way to deploy the database on the target machine?