• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

Application question on SQL Server

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
Basicfarmer
Asked:
Basicfarmer
  • 2
  • 2
1 Solution
 
ktaczalaCommented:
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
 
BasicfarmerAuthor Commented:
Thanks ktaczala, i was reading about SQL Compact it sounds interesting. Can you tell me anything about that?
0
 
ktaczalaCommented:
I have not used it.  I give the user the option to install SQL 2014 Express.  If they do I install it silently.
0
 
BasicfarmerAuthor Commented:
Thanks for your comments...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now