Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Minimal installation of SQL Server 2012 on a dev pc [closed]

My new development pc is arriving tomorrow and I am assembling the software suite I will be installing on it.

Sadly SQL server is still a requirement, and I am installing the Sql 2012 Standard, as the Developer Version is a special version of the Sql Server Enterprise, which can be uncompatible in some cases.

So the question is: How do I install SQL Server on a development pc in a whay that leaves minimal footprint on the computer, while still giving a fully usable environment for development?

like image 211
Bjørn Otto Vasbotten Avatar asked Aug 27 '12 11:08

Bjørn Otto Vasbotten


People also ask

Can we install SQL Server 2012 on Windows 10?

Microsoft SQL Server 2005 (the release version and service packs) and earlier versions of SQL Server are not supported on Windows 10, Windows Server 2016, Windows Server 2012 R2, Windows Server 2012, Windows 8.1, or Windows 8.

How do I fix a SQL Server installation error?

Launch the SQL Server Setup program (setup.exe) from SQL Server installation media. After prerequisites and system verification, the Setup program will display the SQL Server Installation Center page. Click Maintenance in the left-hand navigation area, and then click Repair to start the repair operation.


1 Answers

The very minimum is to select Database Engine only during setup. If you use a the command line, select only SQLEngine feature. If you use the GUI setup, select only the Database Engine from the feature selection page. By installing Database Engine feature only you get the sqlservr.exe service,sqlcmd and bcp tools, network and service configuration applets... and not much else.

If you need other features, like SQL Server Management Studio, make sure you select those as well. Ditto for Replication, Fulltext, tools (eg. Profiler) etc etc.

like image 60
Remus Rusanu Avatar answered Nov 03 '22 14:11

Remus Rusanu