[dba-VB] C# - using SQL Server Express

 > PS: The install of SQL Server 2008 Express R2 on one of my workstations with 2005, 2008, and 2008 
Express mixed installations brought that workstation down to a complete reinstall. Not a good day.

Not what you would want happening when a game installs.  ;)

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 1/16/2012 11:45 AM, Gustav Brock wrote:
> Hi John
>
> I've had some troubles with SQL Server 2008 R2 Express install in general, though not - as I haven't had a need for it - for deploy as described here:
>
> http://connect.microsoft.com/SQLServer/feedback/details/586624/why-is-deploying-sql-server-2008-r2-sooooo-frustrating
>
> yet with some hope here:
>
> http://robindotnet.wordpress.com/2011/02/06/how-about-a-bootstrapper-package-for-sqlserver-express-2008-r2/
>
> so you may choose to stick with SQL Server 2008 Express or even 2005.
>
> /gustav
>
> PS: The install of SQL Server 2008 Express R2 on one of my workstations with 2005, 2008, and 2008 Express mixed installations brought that workstation down to a complete reinstall. Not a good day.
>
>
>>>> jwcolby at colbyconsulting.com 16-01-2012 17:13:59>>>
> I have been working on a small game, for which I need a database.  It will be a single or
> multi-player game which means I need to be able to create a database and install SQL Server Express
> (for the standalone game) or connect to an database (for the multi-player game).  While I am
> reasonably conversant in databases, I have never had a C# program install SQL Server Express.
>
> Once Express is installed, should I ship an empty database?  Should I generate scripts to create the
> tables and autofill the lookup tables?
>
> So much to know, so little time.