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;