sql-serverssmslocaldb

How can I access SQL Server LocalDB in the SQL Server Import and Export wizard


I have a SQL Server LocalDB and can connect and access it from an ASP.NET application, via connection string and this code:

services.AddDbContext<DataContext>(options =>
{
    options.UseSqlServer(conString);
});

I can also connect to this localdb with Microsoft SQL Server Management Studio.

But I cannot connect to it in the Import & Export Wizard. Which "Destination" should I choose there? "SQL Server Native Client" or ".NET Framework Data Provider for SQL Server" or something else?

My connection string that works is from the .net App is: "Server=(localdb)\MSSQLLocalDB;Database=SBot1070"

The "Server Name" property in the working SSMS connection is "(localdb)"


Solution

  • That worked:

    SQL Server Native Client
    (localdb)\MSSQLLocalDB

    enter image description here