Solved

Application question on SQL Server

Posted on 2014-09-19
4
255 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Transaction Monitoring Vs. Real User Monitoring

Synthetic Transaction Monitoring Vs. Real User Monitoring: When To Use Each Approach? In this article, we will discuss two major monitoring approaches: Synthetic Transaction and Real User Monitoring.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Having just graduated from college and entered the workforce, I don’t find myself always using the tools and programs I grew accustomed to over the past four years. However, there is one program I continually find myself reverting back to…R.   So …
This theoretical tutorial explains exceptions, reasons for exceptions, different categories of exception and exception hierarchy.
The viewer will be introduced to the member functions push_back and pop_back of the vector class. The video will teach the difference between the two as well as how to use each one along with its functionality.

695 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