USE:
- heidisql_12.1.0_64.r6540
I will have:
- c:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe
- c:\Program Files\Microsoft SQL Server\150\Tools\Binn\SqlLocalDB.exe
- multiple mdf files. The files are located in different folders.
Example:
- I opened the Windows command prompt;
- I entered the command `sqllocaldb info MSSQLLocalDB';
- I received:
C:\Users\Root>sqllocaldb info MSSQLLocalDB
Name: MSSQLLocalDB
Version: 15.0.4153.1
Shared name:
Owner: HOME-PC\Root
Auto-create: Yes
State: Stopped
Last start time: 28.08.2022 14:48:09
Instance pipe name:
Questions.
- How do I open one
mdf
file in HeidiSQL? - How do I open multiple
mdf
files in HeidiSQL?
Note. I have studied the topic: Unable to connect to LocalDB with HeidiSQL--stackoverflow.com.
It works for me.
I did:
- I opened a C# Visual Studio project;
- in Visual Studio, in the server Browser, I connected to
db1.mdf
; - I performed the steps described in
Unable to connect to LocalDB with HeidiSQL--stackoverflow.com .
; - I connected in
Heidisql
todb1.mdf
;
BUT!!!
How to connect in Heidisql
to db1.mdf
without using Visual Studio?
In other words:
- I opened the Windows command prompt;
- I entered the command
sqllocaldb info MSSQLLocalDB
; - I got:
State: Stopped
;
Further see the section `Questions'.