title: How can I deploy the SQL server database with my setup and deployment project in Visual Studio 2010?
body: <p>My scenario : </p>
  
  <p>I have a Windows Forms application in Visual Studio 2010 and a database in SQL Server 2008 R2. I have created the setup and deployment project for this application which produces the <code>.exe</code> file and installs the application on a client PC. But it needs to install SQL Server 2008 R2 and create the database with the same name that we have in our pc then we generate the database script from my pc and run on the client pc on SQL Server 2008 R2, change the name of server in <code>app.config</code> file, then it runs successfully. </p>
  
  <p>Here is the problem:</p>
  
  <p>This is ok for single user but if I have many clients it will need that I do all the process for all the users. e.g (Install SQL Server on their Pc and configure it for my application)</p>
  
  <p>What I want : </p>
  
  <p>I want to add my data base in set up so that I no need to install the SQL Server on client system and do all the steps. </p>
  
  <p>Could anybody please help me in doing this as I am new to C#, I have already spent many days on it.</p>
  
  <p>Thanks in advance</p>