This blog explains how to create an install set for SQL 2008 Tools with or without BIDS (Business Intelligence Development Studio).
The full SQL 2008 install disk is about 3.5gb, when only a small portion of that is required to install the SQL 2008 Tools. Running the script below will reduce the install size to about 500mb - a much more manageable size.
We found this script online, and have modified slightly to include BIDS.
We are not suggesting the infringement of any copyrights. Please ensure that you have purchased the correct licenses.
Instructions:
Open Notepad and copy the following code into the document. Edit the source and destination in the code according to your preference.
When you have changed the relevant areas, hit File>Save As and save the file as a .bat and name it appropriately. We named ours “CreateSQLToolsWithBIDS.bat”.
Then run....
The scripts below require Robocopy. If you do not have Robocopy, you can find it online. Feel free to contact us if you need assistance with this.
This is the original script which was found online, click here to visit the site.
///Begin Script///
set source=D:\
set dest=C:\SQL08Tools
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///
This is the script which includes BIDS in the install.
///Begin Script///
set source=D:\
set dest=C:\SQL08Tools
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///
