I have two versions (2012, 2014) of SQL Server Express LocalDB installed in my system.
How can I find all existing LocalDB
instance names?
I found a way to do that using command line as mentioned in the answers section.
Is there a better and easy way to do it?
5条答案
按热度按时间hs1ihplo1#
I found SqlLocalDB utility that needs to be run on command line.
SqlLocalDB can be found in
or
To get all existing
LocalDB
instance names, use:To get detailed information about a specific
LocalDB
instance:wlsrxk512#
To list all
localdb instances
, take a look vineel's answer !If you want to list all
databases
of your defaultlocaldb
instance using UI, look here (might not work with SSMS2019 anymore):Just open your SSMS and connect to
(LocalDB)\MSSQLLocalDB
.Now you will see all your LocalDB-Instances.
This works at least with SS2016.
tjrkku2a3#
Here is the method i am using to get all instances from command line -
bjp0bcyl4#
在Visual Studio 2017中,SQL Server对象资源管理器将显示所有LocalDb示例
v8wbuo2f5#
In Visual Studio 2019***Server Explorer*** (or SQL Server Object Explorer button there) click "Add SQL Server" button
and expand the Local tab to view the list of local SQL Server currently running services it finds. Only when you connect to the selected server it will get listed in SQL Server Object Explorer: