Including demo database in installation pack

I have a C# program which is using Sql Server 2008 R2 to store data. I have a problem with deploying the application, because I want to include a demo database in the installation pack, so that its easier for users to test. Is there a 开发者_JAVA技巧way to do this?

This is not simple. Your installer will have to install SQL Server, possibly a silent install. But the machine may already have it installed. In which case they will not want you to uninstall it but instead use that install.

An easier approach might be to require that the Sql Server 2008 R2 is already installed, ask for it's connection properties and create your schema in that instance during the install.

Can you consider installing/using the SQL Server Compact Edition, just for the demo database? Presumably the demo data will be small and it would be straightforward to add the CE edition to your regular setup.