2

I have two different local versions of SQL Server on my machine:

  1. (localdb)\MSSQLLocalDB
  2. localhost

Local SQL Servers

I think one of them might have been installed alongside Visual Studio, but I am not sure. Is there a difference between these two (other than the version number)?

And if I only want to keep one of them, which one should it be? I am only using it for local stuff, while developing...

Improve this question

1 Answer 1

Reset to default
3

LocalDB is installed by Visual Studio and is intended to be minimal configuration for development work. Check out here.

If you want to keep just one, I'd go for SQL Express as you can easily connect to there for your development work.

Improve this answer
2
  • SQL Express bring LocalDB? Aka the one installed by Visual Studio?
    – Jakob Busk Sørensen
    Commented Mar 29, 2020 at 11:19
  • 1
    Sorry, i meant your localhost version - had SQL Express in my brain from other things at the time.
    – Martin Cairney
    Commented Mar 29, 2020 at 22:21

Not the answer you're looking for? Browse other questions tagged or ask your own question.