How to work with LocalDB with an mdf database?

pemoch's profile image pemoch posted 2 years ago in General Permalink

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.

  1. How do I open one mdf file in HeidiSQL?
  2. 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 to db1.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'.

pemoch's profile image pemoch posted 2 years ago Permalink

Is it possible to get a solution on this issue? Or does heidi not solve this issue?

ansgar's profile image ansgar posted 2 years ago Permalink

There is no support for mdf files in HeidiSQL.

Please login to leave a reply, or register at first.