Several customers have asked how to create a source media drop that only contains the management tools. SQL Server 2005 had a Tools folder, but this was removed in SQL Server 2008 as the source media layout was changed. The SQL Server 2005 source media layout caused problems when a customer would copy the Servers folder to a network shared and did not include the Tools folder. Below, I have a script that you can use to create a tools only drop from your original SQL Server 2008 source media, excluding the SQL Server Express source media. This script will produce a drop that is 538 MB versus 4.39 GB for the full media.
This script is not fully supported and tested by Microsoft, but I will assist folks if needed and as time permits.
To create the smallest size tools drop, I have removed the components to install on a 64-bit machine or into WOW64.
Prior to any deployment, please ensure you verify the drop installs and the features you need are installed and working correctly
This drop is ONLY supported on a 32-bit system. I will consider expanding as time permits.
The script requires robocopy.exe
You need to set the source in the script (e.g. if your source media is on the DVD (D: drive), the %source% variable would be D: without the “\”)
//// Begin script /////
REM Copy Root ONLY
robocopy %source% %dest%
REM Copy Root of x86 ONLY
robocopy %source%\x86 %dest%\x86 /XF fixsqlregistrykey_ia64.exe fixsqlregistrykey_x64.exe
robocopy %source%\x86\1033 %dest%\x86\1033
robocopy %source%\x86\help %dest%\x86\help /S
REM Copy redists
robocopy %source%\x86\redist\DotNetFrameworks %dest%\x86\redist\DotNetFrameworks /S /XF *x64* *ia64* /XD x64
robocopy %source%\x86\redist\Powershell %dest%\x86\redist\Powershell /S /XD ia64 x64
robocopy %source%\x86\redist\Watson %dest%\x86\redist\Watson /S
robocopy “%source%\x86\redist\Windows Installer” “%dest%\x86\redist\Windows Installer” /S /XD ia64 x64
REM Setup Folder and exclude folders and files that aren’t needed
robocopy %source%\x86\Setup %dest%\x86\Setup /S /XD sql_engine_core_inst_loc_msi sql_engine_core_inst_msi sql_engine_core_shared_loc_msi sql_engine_core_shared_msi x64 /XF rsfx.msi rsSharePoint.msi sql_as.msi sql_bids.msi sql_fulltext.msi sql_is.msi sql_rs.msi sqlbrowser.msi SQLServer2008_BOL.msi Synchronization.msi SyncServicesADO.msi sql_as_loc.msi sql_is_loc.msi sql_rs_loc.msi sqlserver2005_bc.msi sqlwriter.msi
//// End script /////