====== Local DB ======

===== Upgrade =====
VS 2019 ships with a local DB install version of SQL 2016 -- trying to deploy 2017+ features (e.g. ''STRING_AGG'', computed columns in columnstore indexes) will fail.

Upgrade it like this (thanks [[https://knowledge-base.havit.eu/2018/09/04/sql-localdb-upgrade-to-2017-14-0-1000/|HAVIT]]!):

  -- [[https://download.microsoft.com/download/E/F/2/EF23C21D-7860-4F05-88CE-39AA114B014B/SqlLocalDB.msi|Download]] the Local DB 2017 MSI
  -- Run the installer
  -- <code dos>sqllocaldb stop MSSQLLocalDB
sqllocaldb delete MSSQLLocalDB
sqllocaldb create MSSQLLocalDB</code>
  -- Re-attach your original database MDFs

===== Connect =====
Connection string:
<code>Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=your_db_here;</code>

{{tag> tsql localdb}}