Is there a runtime version of Sql Server?

I am developing a simple application that will be distributed widely, to be run locally on an individual's machine. Right now it's an MS Access d.b. I'd like to move it to Sql Server, but is there a runtime version of Sql Server? How does one distribute an application that needs a database?
LVL 1
Alaska CowboyAsked:
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.

Anthony PerkinsCommented:
You can download and use MSDE or SQL Server Express for free.  Both of them are functionally equivalent to their big brothers and run as services.  That means they are NOT a file based database like MS Access and have to be installed.

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
Alaska CowboyAuthor Commented:
I'd like to avoid having a user download MSDE or Sql ServerExpress. What kind of alternatives do I have if I want the user to install the app and get going?
AneeshDatabase ConsultantCommented:
You can go for the developer editions of sql server
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Alaska CowboyAuthor Commented:
anneshattingal, I have the developer versions. So this will act as a runtime, and someone not having Sql Server on their machine can load this app and start using it?
Anthony PerkinsCommented:
>>I'd like to avoid having a user download MSDE or Sql ServerExpress. <<
Have you considered including either one in your installation?  But you may want to read the fine print on licensing on this issue.

The bigger question is are you prepared to develop and support an application using SQL Server technology?  Again, this is not your home-grown file database.
Anthony PerkinsCommented:
>>So this will act as a runtime, and someone not having Sql Server on their machine can load this app and start using it?<<
Only if you want to violate your license.
Anthony PerkinsCommented:
So that we are clear:  You cannot install a developer edition for a production application, you can only use it (you guessed it) for developing.
Alaska CowboyAuthor Commented:
acperkins

>>The bigger question is are you prepared to develop and support an application using SQL Server technology?  Again, this is not your home-grown file database<<
      Actually, I can develop in Sql Server or Access, so yes I can do this

>>So that we are clear:  You cannot install a developer edition for a production application<<
      Sounds like I'm back to my original question, what can I use for a d.b. to distribute an application? I've never used a file based application (except for Access).

      What I'm actually trying to do is develop a .net application, and it just doesn't seem right to distribute a .net application with an Access d.b. - - know what I mean?
Anthony PerkinsCommented:
>>Actually, I can develop in Sql Server or Access, so yes I can do this<<
Develop is the trivial part.  The bigger question is are you prepared to support it.

>>Sounds like I'm back to my original question, what can I use for a d.b. to distribute an application? <<
Which takes me back to my original response.  If you want to use SQL Server technology, than the least expensive product is MSDE (if you can find it) or SQL Server Express.

>>What I'm actually trying to do is develop a .net application, and it just doesn't seem right to distribute a .net application with an Access d.b. - - know what I mean?<<
I know exactly what you mean.  I felt the same thing about Visual Basic 5 ...
Alaska CowboyAuthor Commented:
Ok, I guess I will investigate MSDE and/or Sql Server Express. Thanks.
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
Microsoft SQL Server

From novice to tech pro — start learning today.