I have designed an accounts software for my clients. I used Sql Server 2008 database with Stored Procedures. It is developed in Visual Studio 2010, dot net framework 3.0. I have more than 500 clients using windows 7.
The major problem is :
Is sql server runtime is automatically installed with dotnet frameworks ? As MS Access database does not required Office to be installed on client.
I can not installed sql server 2008 on each client, its a tough job. Also the clients are not having a good knowledge of installation process.
How to run sql server database on clients without installing its setup on clients ? Is there any runtime files or setup ?
Option 1 - Setup Project:
Using Visual Studio you can create a setup project and install prerequisites that you need during installation.
The installation process is very simple and the end user can install application and prerequisites after clicking next buttons.
When setting prerequisites, its enough to select SQL Server Express.
Option 2 - ClickOnce:
Using Visual Studio another option is using ClickOnce publishing.
In properties of your project, in publish tab, click prerequisites button, you can select SQL Express in prerequisites. This way, you only need to set your database files to copy in output directory, and use AttachDbFileName in connection string:
Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\Database.mdf; Initial Catalog=Master"
Steps for Creating a Setup Project:
1- Create a c# Windows Forms Application
2- Create a Setup Project
It's that easy.