[Updated on 2/16/2010: Corrected an issue with step #6]
In today’s blog I will show you have to create a drop of SQL Server 2008 Management Studio Express with Service Pack 1. Without these steps, you need to install the original release of Management Studio Express and then apply Service Pack 1. Once you run these steps, you can now install the original release of Management Studio Express and SP1 together.
These steps minimize an increase in package size. There are ways for you package up this drop for distribution, but I’m not going to cover these steps at this point in time.
These instructions are specifically for the x86 package, but could work for x64. I just have not worked through the exact steps.
These steps create a folder called merge, which contains Management Studio Express with Service Pack 1.
1. Download & Save (don’t RUN) the x86 SQL Server 2008 Management Studio Express (SQLManagementStudio_x86_ENU.exe) package from here.
2. Download & Save (don’t RUN) the x86 SQL Server 2008 Service Pack 1 (SQLServer2008SP1-KB968369-x86-ENU.exe) package from here.
3. Extract the packages as follows:
4. Run this Robocopy command to create the merged drop
robocopy c:\temp\rtm c:\temp\merge /s
5. Run these commands to copy files from the SP1 drop to the original media folder
robocopy C:\temp\sp1\x86 C:\temp\merge\x86 /XF Microsoft.SQL.Chainer.PackageData.dll
robocopy C:\temp\sp1 C:\temp\merge Setup.exe
robocopy C:\temp\sp1 C:\temp\merge Setup.rll
6. Run these commands to create an optimized SP1 folder
robocopy C:\temp\sp1 c:\temp\merge\pcu mediainfo.xml
robocopy C:\temp\sp1\x86 c:\temp\merge\pcu\x86 microsoft.sql.chainer.packagedata.dll
robocopy C:\temp\sp1\x86\Setup c:\temp\merge\pcu\x86\Setup sql_ssms.msp
robocopy C:\temp\sp1\x86\Setup\1033 c:\temp\merge\pcu\x86\Setup\1033 sql_ssms_loc.msp
robocopy C:\temp\sp1\x86\Setup\1033 c:\temp\merge\pcu\x86\Setup\1033 sqlsupport.msi
robocopy C:\temp\sp1\x86\Setup\sql_common_core_msi c:\temp\merge\pcu\x86\Setup\sql_common_core_msi sql_common_core.msp
robocopy C:\temp\sp1\x86\Setup\x64 c:\temp\merge\pcu\x86\Setup\x64 /S
robocopy C:\temp\sp1\x86\Setup\x86 c:\temp\merge\pcu\x86\Setup\x86 /S
robocopy C:\temp\sp1\x86\setup\1033\pfiles C:\temp\merge\pcu\x86\Setup\1033\pfiles /s
robocopy C:\temp\sp1\x86\setup\1033\windows C:\temp\merge\pcu\x86\Setup\1033\windows /s
7. Create a defaultsetup.ini file to tell Setup where to find the Service Pack
echo [SQLSERVER2008] > C:\temp\merge\x86\defaultSetup.ini
echo PCUSOURCE=".\PCU" >> C:\temp\merge\x86\defaultSetup.ini
8. Additional notes:
a. You no longer need the c:\temp\rtm and c:\temp\sp1 folders
b. You should verify the installation works as expect, run setup.exe in the \merge folder
c. You can package up the merge folder for distribution