Using SQL Express With Commerical Apps

Posted on 2007-10-04
Last Modified: 2010-04-15
My expertise is in PHP and MySQL. However i am working through making a C# Program. This program is going to be run on a computer and i want to store the data locally. Since im used to MySQL and i like the advantages of databases over a flat file/xml file but I am unsure of if its possible.

I know that SQL Server Express from Microsoft is a free SQL server that is designed to run on a local machine and not as a large SQL server. What i am not sure of is if i can package SQL Server Express into an Application Installer and have it streamlined into the Install of my software, and if it is ok to do so legally. I would prefer to not have to tell people to Download it and set it up on their own as that is potetionally error prone and would instead prefer to streamline it into my Installer.

If i cannot do this, is Flat file/XML file my only other option?
Question by:dstufft
    LVL 5

    Assisted Solution

    Look int a opensource db called firebird.  Works just like sql.
    Has two configuration options server and local.  Local only requires a dll to run.

    Sql express is free to distribute. I personally find it intrusive to install.
    LVL 21

    Accepted Solution

    The answer is probably yes if you don't mind registering with Microsoft for redistribution rights:

    and I haven't used it but one of the "features" on SSE is a silent installation mode for embedded use.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Extention Methods in C# 3.0 by Ivo Stoykov C# 3.0 offers extension methods. They allow extending existing classes without changing the class's source code or relying on inheritance. These are static methods invoked as instance method. This…
    Introduction                                                 Was the var keyword really only brought out to shorten your syntax? Or have the VB language guys got their way in C#? What type of variable is it? All will be revealed.   Also called…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now