How to deploy an application with SQL Server databases on clients

Question

I have developed account software for my clients. I used the Sql Server 2008 database with stored procedures. It was developed in Visual Studio 2010, dot net framework 3.0. I have over 500 clients using Windows 7.
The main problem is this:

Is the sql server runtime environment automatically installed using dotnet networks? Since the MS Access database does not require Office to be installed on the client.

I can not install SQL Server 2008 on each client, its hard work. In addition, customers are not aware of the installation process.

How to start a SQL Server database on clients without setting its configuration on clients? Are there any runtime files or settings?

Answer 1

Option 1. Project setup:

Using Visual Studio, you can create an installation project and install the necessary components during installation.

The installation process is very simple, and the end user can install the application and the necessary components after clicking the following buttons.

1. How to: create or add an installation project

2. How to install prerequisites when deploying Windows Installer

3. Walkthrough Using a custom action to create a database during installation

When installing the prerequisites, just select SQL Server Express.

Option 2 - ClickOnce:

Visual Studio - ClickOnce.
, SQL Express . , AttachDbFileName : Data Source=.\SQLEXPRESS; AttachDbFilename=|DataDirectory|\Database.mdf; Initial Catalog=Master"

• ClickOnce

:

---

1- Windows Forms c #

1. # Windows Forms
2. SQL Server
4. .

2-

1. => =>
4. . "", " " "SQL Server Express"
5. . .Net Framework
6. Windows
7. , .
8. " " , , SampleApplication, "" .
9. .
11. setup.exe

.

Answer 2

LocalDB - Microsoft . , SQL Server SqlExpress. SQL-. , .

.

Answer 3

sql express sql express