SearchSQLServer.com

• Home
• Topics
• Microsoft SQL Server Administration
• Microsoft SQL Server Tools and Utilities
• Introduction to SQL Server 2012 Express LocalDB

without much hassle. Developers can more quickly install and use a LocalDB instance when compared to other editions of SQL Server. Remember, though, SQL Server 2012 Express LocalDB has all the limitations of SQL Server 2012 Express Edition.

Installing SQL Server 2012 Express LocalDB

There are some requirements for installing LocalDB. First, you must have Microsoft .NET Framework 4 and Microsoft .NET Framework 4.0.2 Runtime Update (KB2544514). Next, you must have one of the following operating systems: Windows Vista Service Pack 2, Windows 7, Windows Server 2008 Service Pack 2, or Windows Server 2008 R2.

Downloading LocalDB is easy enough. The x86 version for 32-bit operating systems is about 28 MB, while the x64 version for 64-bit OSes is about 33 MB.

Using the SqlLocalDB.exe utility, a database developer can create and manage an instance of SQL Server 2012 Express LocalDB. The SqlLocalDB utility supports different sets of arguments to create, drop, start, stop, share and unshare instances of LocalDB. To learn more about other arguments and syntax that SqlLocalDB supports, see SqlLocalDB Utility.

The next step is to actually install SQL Server 2012 Express LocalDB. Here's a step-by-step guide:

1. Double-click the SqlLocaLDB.MSI file to open Welcome to the Installation Wizard for SQL Server 2012 Express LocalDB as shown in the figure below. Click Next to continue with the installation.

2. In the License Agreement screen, accept the license agreement and click Next.

3. In the Ready to Install the Program screen, click the Install button to start installation of Microsoft SQL Server 2012 Express LocalDB.

4. Once the installation is successfully completed, click Finish.

5. Once you have successfully installed SQL Server 2012 Express LocalDB, the next step will be to connect to the LocalDB instance.

Connecting and creating in SQL Server 2012 Express LocalDB

One can connect to the LocalDB instance using these several methods:

1. You can download SQL Server 2012 Management Studio Express, which is free and can connect to LocalDB.

2. Using SQLCMD, you can connect to LocalDB. SQLCMD can be downloaded from SQL Server 2012 Command Line Utilities from the Microsoft SQL Server 2012 Feature Pack.

3. You can connect to LocalDB using SQL Server Data Tools.

When using SQL Server Management Studio to connect, follow these steps:

In Connect to Server dialog box, specify the Server Name as (localdb)\v11.0, choose the Authentication as Windows Authentication, and click Connect to establish a connection with SQL Server 2012 Express LocalDB.

Once you connect to LocalDB, you can create a new database for your project. Execute the script below in a New Query window of SQL Server Management Studio to create a Demo Database named DemoLocalDB.

CREATE DATABASE [DemoLocalDB]
CONTAINMENT = NONE
ON PRIMARY
(
    NAME = N'DemoLocalDB',
    FILENAME = N'D:\LocalDB\DemoLocalDB.MDF',
    SIZE = 3072KB,
    FILEGROWTH = 1024KB
)
LOG ON
(
    NAME = N'DemoLocalDB_log',
    FILENAME = N'D:\LocalDB\DemoLocalDB_Log.LDF',
    SIZE = 1024KB,
    FILEGROWTH = 10%
)
GO

USE [DemoLocalDB]
GO
IF NOT EXISTS (SELECT name FROM sys.filegroups WHERE is_default=1 AND name = N'PRIMARY')
ALTER DATABASE [DemoLocalDB] MODIFY FILEGROUP [PRIMARY] DEFAULT
GO

Once the database is successfully created, you will see the database in Object Explorer as shown here:

By default, a LocalDB database file such as .MDF, .NDF and .LDF are stored in the following location: “C:\Users\UserName\AppData\Local\Microsoft\Microsoft SQL Server Local DB\Instances\v11.0\”. Hence, you need to reserve enough space for database growth on the local drive. Either that or create the database by specifying the location of data and log file as mentioned in the above TSQL script.

More from Related TechTarget Sites

• Business Analytics
• Data Center
• Data Management
• Data Management UK
• Oracle
• Content Management
• Windows Server

• Business Analytics

  • Survey reveals growing interest in cloud BI and analytics

    TechTarget's recent 2012 Cloud Pulse survey suggests cloud BI and analytics are edging closer to mainstream adoption.

  • Dow Chemical and Wyndham find analytics skills in unfamiliar places

    Analytics skills are a hard-to-find, yet sought-after commodity, but experts from Dow Chemical and Wyndham Rentals share ways to lessen that burden.

  • Predictive analytics programs need open organizational minds

    Using predictive analytics tools can help companies move forward more intelligently, particularly when they welcome new ideas on business strategies and processes.

• Data Center

  • IT security issues: The perception and deception of security

    Consider a few lesser-known IT security issues before resting on your company's current policies.

  • Plan for IT disruptions to continue business as usual

    When plotting out your upgrades and agenda, make sure to include proper planning to save money and avoid frustration.

  • HP unveils cloud-based IT service management product Service Anywhere

    HP's Service Anywhere joins several other cloud-based ITSM offerings, but questions about total cost of ownership could hamper potential sales.

• Data Management

  • IBM executives, customers share 'big data' tips at Information on Demand

    An IBM VP and a user from Sprint took to the stage at the vendor's Information on Demand conference to offer advice on how to make sense of big data.

  • Zornes connects the dots between big data and master data management

    Consultant Aaron Zornes believes that MDM and big data were made for one another.

  • IT pros reveal benefits, drawbacks of data virtualization software

    Attendees at Composite Software's Data Virtualization Day conference had plenty of advice for companies considering a data virtualization project.

• DataManagement UK

  • Big data roundtable webcast: gaining value from big data

    Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).

  • 2012 training courses: BI, data management, data warehousing

    Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.

  • Poor data quality: what is dirty data costing UK organisations?

    Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.

• Oracle

  • Oracle E-Business Suite R12 upgrade aided by checklists

    A pre- and post-upgrade checklist will go a long way toward ensuring a successful Oracle E-Business Suite R12 upgrade.

  • How to copy Oracle Database 9i to a new server

    Expert Brian Peasland explains to one puzzled reader how to copy Oracle Database 9i from one production server to another.

  • The finer points of Oracle applications and Oracle Business Accelerators

    DAZ consulting group's Deborah Arnold takes some time out of OpenWorld to talk about Oracle Business Accelerators and Oracle applications.

• Content Management

  • World of Warcraft offers organizational learning lessons

    John Seely Brown opened up KMWorld by describing a new process of organizational learning that enterprises should embrace to remain competitive in a new era.

  • Information governance policy often a hard sell -- until it's too late

    Establishing an effective information governance policy remains a challenge because it relies on complex corporate cultural efforts, not software to turn on.

  • Content is power behind managing the customer experience

    There are different ways to deliver content for managing the customer experience, but it's essential to use the right ones for successful CEM.

• Windows Server

  • Chkdsk improvements in Windows Server 2012 increase data availability

    Data availability has been an issue for admins running chkdsk, but that's no longer the case in Windows Server 2012. Here's a look at what's changed.

  • Windows Server 2012 release highlights this year's top news stories

    Look back on the top news stories in a pivotal year for Microsoft and its Cloud OS initiative for Windows Server 2012.

  • Why do I get a PowerShell error when trying to access a file?

    One common PowerShell error occurs because of the way PowerShell is told how to access a file. Here's how to fix it and avoid it in the future.

• About Us
• Contact Us
• Site Index
• Privacy policy
• Advertisers
• Business partners
• Events
• Media kit
• TechTarget Corporate site
• Reprints
• Site map