What does LocalDB mean?

Can I use LocalDB in production?

LocalDB is absolutely supported in production. From the performance point of view it is identical to SQL Server Express, as they share the same database engine. Now, for a site running in full IIS I would recommend using service-based instance of SQL Server Express.

What is LocalDB used for?

Description. The LocalDB setup program uses the SqlLocalDB. msi program to install the necessary files on the computer. Once installed, LocalDB is an instance of SQL Server Express that can create and open SQL Server databases.

What is local database?

Local databases reside on your local drive or on a local area network. They often have proprietary APIs for accessing the data. When they are shared by several users, they use file-based locking mechanisms. Because of this, they are sometimes called file-based databases.

How do I connect to LocalDB?

To connect SQL Server Management Studio (SSMS) to the LocalDB system database:1Confirm that the following have been addressed: ... 2Open SSMS: right-click the application icon, and select using the Run As Administrator command. ... 3On the Connect to Server window, connect to the default instance:Connecting Microsoft SQL Server Management Studio - PDXpert PLM