Search code examples
sqlsql-servervisual-studio-2017sql-server-2017

SQL Server 2017 Express LocalDB available?

Is localdb available for SQL Server 2017? I.e. (localdb)\ProjectsV14.

In Visual Studio Professional 2017 (15.5.3) under '.NET desktop development tools' I only see 'SQL Server 2016 Express LocalDB'.

I need this to code locally against SQL Server 2017 functions, targeting Azure production environment.

Solution

  • The local SQL Server Express DB can be obtained from Microsoft SQL Server 2017 Express Download

    Note that the server\instance name has changed:

    • (localdb)\ProjectsV13 (SQL Server 2016)
    • localhost\SQLEXPRESS (SQL Server 2017)