Solved

Application question on SQL Server

Posted on 2014-09-19
4
248 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
How to remove superseded packages in windows w60 or w61 installation media (.wim) or online system to prevent unnecessary space. w60 means Windows Vista or Windows Server 2008. w61 means Windows 7 or Windows Server 2008 R2. There are various …
The goal of the tutorial is to teach the user how to use functions in C++. The video will cover how to define functions, how to call functions and how to create functions prototypes. Microsoft Visual C++ 2010 Express will be used as a text editor an…
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.

770 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