Thursday, November 27, 2014

Connecting to LocalDB using SQL Server Management Studio

If you have an application (such as a sample Visual Studio application) that uses LocalDB and you want to move the application to IIS for scalability reasons, odds are, you will need to connect to the LocalDB instance, create a backup and then move it to the full version of SQL Server.

So, how do you connect to your LocalDB instance using SQL Server Management Studio?

Well, actually, the answer is very simple!

You can simply connect to LocalDB using the following path in SQL Server Management Studio: 
(localdb)\V11.0





Of course, when you take a backup of the LocalDB database, you will only be able to specify the original User Profile location such as Users\<username>\<database name>.bak




However, once you have the database backup, you can readily move it over to the full version of SQL Server!

No comments:

Post a Comment