sql-serverasp.net-corelocaldb

MSSQLLOCALDB databases aren't listed


I used the ASP.NET 5 Preview Templates in Visual Studio 2015 to create an ASP.NET 5 site. According to the config.json file, there's a database in (localdb)\mssqllocaldb.

I want to move that database to my actual SQL Server, but when I connect to the (localdb)\mssqllocaldb server in SQL Server Management Studio to start the backup process, there are no databases listed. Where is it?

Any idea on how I can migrate that database if I can't find it in SSMS?


Solution

  • On the "Connect to Server" login, there is an "Options" button. That opens a "Connection Properties" tab that lets you find specify a database, either by manually entering the name or browsing for it. When connecting that way, it does appear in the list.