3

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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Martin Thøgersen
  • 1,538
  • 18
  • 33

1 Answers1

2

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)
marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Martin Thøgersen
  • 1,538
  • 18
  • 33
  • The default LocalDB instance for SQL Server 2016 for devs to use is [`MSSQLLocalDB`, not `ProjectsV13`](https://stackoverflow.com/a/27201328/145173). – Edward Brey Oct 31 '18 at 01:52
  • Edward Brey, did it change name or is it a different service? – Martin Thøgersen Nov 01 '18 at 04:43
  • They are separate LocalDB instances with [separate purposes](https://stackoverflow.com/a/23658871/145173). MSSQLLocalDB is for applications; ProjectsV*x* is for SSTD. – Edward Brey Nov 01 '18 at 11:31