views:

2945

answers:

1

anyone have script or procedures to install SQL Server 2008 Express, set up the database for the app and finally install a client .NET WinForm application?

+2  A: 

In situations like this where I'm relying on third-party products (SQL Server Express), I tend to use command-line driven installs (either directly in a cmd file or called from a 'proper' install tool). This site shows you how to install Express from the command line, then you can use the SQL Express utility for object creation. This method is 'blessed' by Microsoft.

Sometimes the simplest solution is the best, even if that means getting the user of my product to install SQL Express separately before running my install. Well, best for me, anyway :-)

paxdiablo
Your example is truncated. The full code is here:http://www.experts-exchange.com/Programming/Installation/Q_23868626.html
dcraggs
Yeah, not sure what happened there. It *was* complete and, in fact, the links still worked, despite them not being in the edit box. This may be lost data from SO. In any case, we ended up using the other method so I've edited the answer - it's very simple to do and a lot safer than the other non-blessed solution. I also refuse to have to sign up with that site (and pay) you linked just to get solutions. SO's model is so much better.
paxdiablo