LocalDB SQL Server 2014 Express 创建2个实例(localdb)ProjectsV12 &(localdb)MSSQLLocalDB? [英] LocalDB SQL Server 2014 Express creates 2 instances (localdb)ProjectsV12 & (localdb)MSSQLLocalDB?
问题描述
我正在使用 SQL Server 2014 Express 和 LocalDB 选项,并且在 Visual Studio 2013 的 SQL Server 对象资源管理器窗格中有以下内容...
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...
那么 (localdb)ProjectsV12
和有什么区别?(localdb)MSSQLLocalDB
?
So what is the difference between (localdb)ProjectsV12
& (localdb)MSSQLLocalDB
?
推荐答案
(localdb)ProjectsV12 和 (localdb)ProjectsV13 实例由 SQL Server Data Tools (SSDT) 创建,不应由应用程序使用
The (localdb)ProjectsV12 and (localdb)ProjectsV13 instances are created by SQL Server Data Tools (SSDT) and should not be used by applications
(localdb)MSSQLLocalDB 是 SQL Server Express 2014/2016 LocalDB 默认实例名称和自动实例".
(localdb)MSSQLLocalDB is the SQL Server Express 2014/2016 LocalDB default instance name and an "automatic instance".
可以使用sqllocaldb.exe命令行工具来管理哪个版本(2014或2016)拥有MSSqlLocaldb实例
You can use the sqllocaldb.exe command line tool to manage which version (2014 or 2016) owns the MSSqlLocaldb instance
而 (localdb)v11.0 是 SQL Server 2012 LocalDB 默认实例名称
And (localdb)v11.0 is the SQL Server 2012 LocalDB default instance name
这篇关于LocalDB SQL Server 2014 Express 创建2个实例(localdb)ProjectsV12 &(localdb)MSSQLLocalDB?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!