title: Creating a database when installing an SAP Business 1 Add on
body: <p>I am creating an SAP Business one add-on payroll application - EIMPayroll. I have created an .ard file and I am able to install this add-on in SAP, ie, going to the add on manager and registering the payroll application using the .exe and .ard files.</p>
  
  <p>However, on the machine that I install this add-on on, I have to manually import/create the Microsoft SQL server database "Eim_payroll.bak" on the computer for this add-on to run.</p>
  
  <p>My question is, is there a way I can write the sql query to create the database and tables needed to run this application on a C# file and then package it together into the ard file such that it installs when I install the add-on in SAP?</p>
  
  <p>I create the ard file using Visual Studio 2010 and using the SAP B1 AddOnInstaller .NET Wizard. My add-on is in C#</p>
  
  <p>Any help will be appreciated, including links on examples of how this is done.</p>