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)"