How can I deploy the SQLserver DB with my application in vs?

sumit gupta

sumit gupta

Oct 28 2014 1:49 AM

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 .exe 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 app.config file, then it runs successfully.

Here is problem:

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)

What I want :

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.

Could anybody please help me in doing this as I am new to C#, I have already spent many days on it.

Thanks in advance

Answers (2)