In order to add features from the full version of SQL Server 2008 R2 to the Express version.
Get a hold of the full version DVD or installation media, then use the following command from the command prompt;
setup.exe /FEATURES=Tools /Q /INDICATEPROGRESS /ACTION=Install /INSTANCENAME=UPSTAIRS\SQLEXPRESS /BROWSERSVCSTARTUPTYPE=Automatic /AGTSVCACCOUNT="NT AUTHORITY\NETWORK SERVICE" /IACCEPTSQLSERVERLICENSETERMS
