How to deploy VB.NET winform application with SQL server and make it usable on other pcs

Question

1.00/5 (2 votes)

See more:

I have developed a winform application linked to an SQL SERVER database. I want to deploy this project so that I can give friends to install for use on their computers.

Example: Just as I can use other app like MS-WORD and more.

Video, handbook and demonstrations are highly welcome.

Thanks in advance.

The project should be in a standard format.

Pls, I need to defend this on Sunday

What I have tried:

I have no idea. All I've tried did not work. That's trying to publish

Posted 25-Apr-19 6:14am

Member 14226225

Updated 25-Apr-19 8:09am

v2

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Richard MacCutchan · Answer 1 · 2019-04-25T06:34:00

Solution 1

SQL server is designed to be shared by multiple users. So you need to install the SQL Server instance on a system that is accessible to all the users. You then just need to publish the application, and its prerequisites, to each user's PC. Google will find many articles on the subject.

Posted 25-Apr-19 6:34am

Richard MacCutchan

OriginalGriff · Answer 2 · 2019-04-25T08:09:00

As Richard says, SQL Server is intended as a multiuser database, which means it is server based and a heavyweight installation which takes knowledge and effort to both install and maintain properly. You should not consider installing SQL Server on any system for your users as that removes all the advantages of using a multiuser DB in the first place!

If you are expecting only a single user, then don't use SQL server - use SQLite, Sql Compact, or even Access instead - they require nothing significant to be added to yoru instal program other than the required DLL files. The changes to your app (if it was written well) should be relatively trivial to support it.