![]() ![]() When I initially installed Visual Studio 2015 I chose custom install and selected all options. I was assisting someone else troubleshoot their installation so I installed Visual Studio 2015 Community Edition on another Win 7 Computer. I chose custom Install and under Windows and Web Development options I chose Microsoft SQL Server Data Tools. It stated 2012 SQL Server, but after install and restarting I had both the 20 SqlLocalDB (under 120 and 130 folders respectively). SQL Server Data Tools install may not be needed unless you need SSIS, SSAS or SSRS which I do need.Īfter all of this you will need SQL Server Management Studio 2016 or higher to connect to the local db and access the 2016 functionality.Īfter you have installed this there should be a SQL Local DB command Line tool installed. The default install location as pointed out by Discosultan may be: D:\Program Files\Microsoft SQL Server\130\Tools\Binn\SqlLocalDB.exe My install location was D:\Programfiles\130\Tools\Binn\SqlLocalDB.exe My install path was different, but that may be due to the several versions and related components of SQL server that I have installed on the PC and the manner of my installs. HKLM\SOFTWARE\Microsoft\Microsoft SQL Server Local DB\Installed Versions\13.0 You can find the install folder path in the registry for SQL 2016 by reviewing the following Registry Entry in HKEY_LOCAL_MACHINE (Abbreviated to HKLM below): Once you have done the install you can search for SqlLocalDB.exe if you have multiple versions and navigate to the 2016 version, (product version 13 in the 130 subfolder). ![]() ![]() You can run the command line from there or add the directory to the path statement. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |