Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Add SQL Server Express "Advanced" features to LocalDB installed by Visual Studio

I installed VS 2013. It installed SQL Server 2012 Express with LocalDB. That's great, except that I need full-text search, and it didn't install "Advanced Services" (and I didn't see an option during install).

I've downloaded SQL Server 2012 Express w/Advanced Services to add this, but it seems to want to install it on a new instance. Does this sound familiar to you? How did you add SQL Server Advanced Services to your LocalDB installation?

I had the same issue last VS version, and resorted to reinstalling SQL Server then. I apologize for coming to the community with a mundane question, but it vexes me. :)

Here's what I did:

  • start the SQL Server Express Advanced install
  • choose to modify an existing instance
  • check "full-text" under Instance Features / Database Engine Services
  • find that the installed instances list is empty at the "Instance Configuration" screen, and it wants to install a new instance
like image 824
shannon Avatar asked Jul 11 '14 17:07

shannon


People also ask

How do I add features to an existing installation of SQL Server 2019?

To add a new feature to an existing instance of SQL Server, select Installation in the left-hand navigation area, and then select New SQL Server stand-alone installation or add features to an existing installation. The System Configuration Checker will run a discovery operation on your computer.

Does Visual Studio install LocalDB?

Alternatively, you can install LocalDB through the Visual Studio Installer, as part of the Data Storage and Processing workload, the ASP.NET and web development workload, or as an individual component.

What is the difference between LocalDB and SQL Express?

\SQLEXPRESS you are looking for a named instance of SQL Server called "SQLEXPRESS" that is on your local machine and connected to via a shared memory interface (that's what the dot is). Local DB is a deployment option for SQL Express that runs as an attached process to another application, instead of as a service.


1 Answers

Looks like this cannot be done, unfortunately.

LocalDB is cool, but apparently not all-powerful.
Check out this existing post (among others):

Can't create an index catalog in localdb v\11.0

like image 148
Mike M Avatar answered Oct 14 '22 11:10

Mike M