Search code examples
c#sql-serveradvanced-installer

What database should I choose for prerequisites?

I have a C# project that I want create a setup for. I use Advanced Installer.

I use SQL Server 2017 Express for creating instance of my database. Now when I want to choose "Prerequisites", I have 2 options:

  1. SQL Server 2017 Express
  2. SQL Server 2017 Express Local DB

What should I choose, and what's the difference?

Solution

  • SQL Server Express LocalDB: This edition is mainly used as a development tool. It is a lighter version of Express that runs as a local app. It does support all the main programmability features of the other editions.

    The big advantage of LocalDB for developers is that it allows them to create a local environment that is much easier to install and manage. Users can just start up an instance of LocalDB runtime as they need it and do not need to install a service.

    For details, please check the SQL Server Express LocalDB article.