The SQL Server 2012 Express LocalDB Release Candidate 0 is now available for download.
“LocalDB is a new version of Express created specifically for developers. It is very easy to install and requires no management, yet it offers the same T-SQL language, programming surface and client-side providers as the regular SQL Server Express,” blogged SQL Server team.
“LocalDB was created so that developers that use SQL Server no longer have to install and manage a full instance of SQL Server Express on their laptops or other machines. Plus, developers can take this into production as it also serves as an embedded database. Click here for more technical details.”
“Originally introduced in CTP3, LocalDB now offers a brand new installer in RC0. With this dedicated, 33MB MSI package, it is now possible to install LocalDB in under a minute,” added the team.
After dowloading “Just pick your CPU architecture (32-bit or 64-bit) and select LocalDB from the drop-down list. Just double-click the SqlLocalDB.msi file is downloaded that will be downloaded. We kept LocalDB simple so there is not a single configuration option in the entire installer. All you need to do is to accept the EULA and click Next a couple times. The installation of LocalDB requires administrative privileges, so if your machine has UAC enabled you will also need to agree to elevate the installation process,” explained SQL Server team.
Silent and Embedded Installation
As any decent installer, LocalDB supports silent installation. Here is an example a command that installs LocalDB silently:
msiexec /i SqlLocalDB.msi /qn IACCEPTSQLLOCALDBLICENSETERMS=YES
“As you can see these’re all standard Windows Installer options, except for the IACCEPTSQLLOCALDBLICENSETERMS variable. Setting it to YES is telling us that the user read and accepted LocalDB EULA. As expected the installer will not continue unless this variable is set to YES.
If you are considering distributing LocalDB with your application, be sure to put 32-bit and 64-bit versions into separate folders. LocalDB doesn’t support installing 32-bit version on 64-bit Windows, so you will need to distribute both versions of LocalDB with your application and they both have the same file name (SqlLocalDB.msi). Renaming LocalDB packages is not an option, as Windows Installer requires that MSI file names don’t change (see Rule 14 in this post for the explanation),” the team added.
You can download SQL Server 2012 Express LocalDB RC0 here.