Solved

Application question on SQL Server

Posted on 2014-09-19
4
240 Views
Last Modified: 2014-09-19
Hello Experts, I am new to SQL Server. I have always used Access database for my client applications. So I am using SQL Server Express Database for my application. But what do I do with it when I am ready to distribute my application? Do the clients need to have SQL Server Express installed on their machines? How do I get the database out of SQL Server? What are the database files that I need to distribute with my application? Is there a SQL runtime or something that I should distribute with the application so the client can use the database?
0
Comment
Question by:Basicfarmer
  • 2
  • 2
4 Comments
 
LVL 12

Accepted Solution

by:
ktaczala earned 500 total points
ID: 40334038
Yes, for the most part SQL would need to be installed. There are some exceptions, for instance an app that I have developed can connect to a SQL server located on another PC/Server (as long as the user has the correct access permissions to it).
The database can be installed / ported with your app.  Then you would need to run some SQL script to attach it to the SQL Server.
Again the app I made, creates the Database through SQL script so I don't need to supply the Database.  
You still need to copy all the SQL resource dll's your app uses (into your app folder is fine)
To get the Database you'll need the SQL Management tools.
0
 

Author Comment

by:Basicfarmer
ID: 40334051
Thanks ktaczala, i was reading about SQL Compact it sounds interesting. Can you tell me anything about that?
0
 
LVL 12

Expert Comment

by:ktaczala
ID: 40334058
I have not used it.  I give the user the option to install SQL 2014 Express.  If they do I install it silently.
0
 

Author Closing Comment

by:Basicfarmer
ID: 40334102
Thanks for your comments...
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This article is meant to give a basic understanding of how to use R Sweave as a way to merge LaTeX and R code seamlessly into one presentable document.
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
The goal of the video will be to teach the user the concept of local variables and scope. An example of a locally defined variable will be given as well as an explanation of what scope is in C++. The local variable and concept of scope will be relat…
The viewer will learn how to clear a vector as well as how to detect empty vectors in C++.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now