LocalDB SQL Server 2014 Express creates 2 instances (localdb)\ProjectsV12 & (localdb)\MSSQLLocalDB?

visual-studio-2013 localdb sql-server-2014
Kasper Roma picture Kasper Roma · Nov 29, 2014 · Viewed 22.8k times · Source

I'm using SQL Server 2014 Express and the LocalDB option, and I have the following in my SQL Server object explorer pane in Visual Studio 2013...

enter image description here

So what is the difference between (localdb)\ProjectsV12 & (localdb)\MSSQLLocalDB?

Answer

ErikEJ picture ErikEJ · Nov 29, 2014

The (localdb)\ProjectsV12 and (localdb)\ProjectsV13 instances are created by SQL Server Data Tools (SSDT) and should not be used by applications

(localdb)\MSSQLLocalDB is the SQL Server Express 2014/2016 LocalDB default instance name and an "automatic instance".

You can use the sqllocaldb.exe command line tool to manage which version (2014 or 2016) owns the MSSqlLocaldb instance

And (localdb)\v11.0 is the SQL Server 2012 LocalDB default instance name

Related questions

System.Data.DataException error occurred in EntityFramework.dll

I have been following this tutorial Getting Started with Entity Framework 6 Code First using MVC 5. When I got to the section where I need to run the program and click on Student so that the program would create database I …

Read More
SQL LocalDb Automatic Instance Startup Failure when called from Visual Studio 2013, but not SQL Server Management Studio

Per MSDN Docs: http://msdn.microsoft.com/en-us/library/hh510202.aspx LocalDB supports two kinds of instances: Automatic instances and Named instances. I suspect this has something to do with my problem, so I am wondering if anyone knows how …

Read More
SQL Server CE and Visual Studio 2013

So we now know that SQL Server CE is no longer supported with Visual Studio 2013. We can get some access to it via the SQL Server CE Toolbox add-in, but this does not fix the fact that a data provider …

Read More