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?
BasicfarmerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Visual Basic.NET

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.