How to connect to MS SQL LocalDb?

How to connect to MS SQL LocalDb
What is LocalDB and how can you connect to it using SQLBackupAndFTP?

LocalDB was first introduced with the CTP3 version of SQL Server 2012. Basically, it is a newer version of SQL Server Express, which has the same characteristics in terms of functionality, but it is mostly dedicated to developers.

It does not require you to install any SQL server. If you have installed SQL 2012 or Visual Studio 11 or higher then you already have LocalDB. Also, it runs only on .Net 4.0 and higher.

How to connect to MS SQL LocalDb

You can connect to a named instance of SqlLocalDB with SQLBackupAndFTP just  by entering the string (LocalDB)<instance-name> into “SQL Server Name” at the SQL Server section.

How to connect to MS SQL LocalDb

Where <instance-name> is your named instance of SQL LocalDB.

[Total: 1    Average: 5/5]

About Radu Gheorghiu

Passionate SQL Developer on the journey of trying to become an expert in all things Data (storage, manipulation, gathering etc.) Information is power, and information can only be obtained from data. Thus, in order to harness the power of information, you must be a master of Data.

Leave a Reply

Your email address will not be published.