How to deploy Windows app with SQL Server database?

Question

1.00/5 (4 votes)

See more:

VS2012

, +

I have developed an application in Visual Studio 2012 with a SQL Server 2012 database. When I try to publish the application to test it, it works correctly on my machine (that includes the database in a SQL Server data folder), but when I move that published app to another machine it doesn't work.

I want to know the simplest way to deploy the project together with its database. I have seen a solution to integrate the SQL database with my application is to use a localdb but I don't understand the steps to use it. I need all the steps to deploy an application with a SQL Server 2012 database in order to install the application on another PC without having to install SQL Server 2012 on that PC.

Posted 10-Jun-15 14:31pm

Mohammed-cd7

Updated 10-Jun-15 15:07pm

PIEBALDconsult

v2

Add a Solution

Comments

njammy 10-Jun-15 20:45pm

Do you have access to a SQL Server instance? Ideally you should create scripts from your localdb mdf database (manually or via SSMS) and run on the live server.
Then point the app to the new db on live, using app.config connection strings.

PIEBALDconsult 10-Jun-15 21:08pm

Is it a multi-user application? If it is, you don't want localdb.

[no name] 17-Jun-15 2:32am

Nice post

Richard Deeming 11-Jun-15 8:21am

REPOST
You have already asked this question:
http://www.codeproject.com/Messages/5072567/How-to-deploy-Windows-app-with-SQL-Server-database.aspx[^]

1 solution

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)

Sergey Kizyan · Answer 1 · 2015-06-11T02:28:00

Your appliction needs to connect to some DB. There is no way that you will deploy without SQL DB on another system or you need to have SQL DB somewhere in the cloud to connnect from all the other systems.

I advice you to switch to file based DB as MySQL then you will deploy with single file and it will work.