Local DB

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 HAVIT!):

  1. Download the Local DB 2017 MSI

  2. Run the installer

  3. sqllocaldb stop MSSQLLocalDB
    sqllocaldb delete MSSQLLocalDB
    sqllocaldb create MSSQLLocalDB
  4. Re-attach your original database MDFs

Connection string:

Data Source=(LocalDb)\MSSQLLocalDB;Initial Catalog=your_db_here;