How to create a autorun/.exe file of database

I'm developing a CMS and I'm using SQL Server with it. I want to automatically create my database in SQL Server 2008 when my app is installed.

I can generate a script. I'm wondering that there might be a way that I can install SQL script i开发者_开发技巧n a database using an MSI file.

e.g. in this link we can install database using a MSI file

http://www.microsoft.com/download/en/details.aspx?id=23654

I just wanna know how can we do it. Is it created using SQL Server or Visual Studio

you can attach a database through the app.config. in your installation you should copy this database to the right place.

Look here how to set your connection string: http://www.connectionstrings.com/sql-server-2008