升級原Visual Studio 2010之SQL Server 2008 SP1至SQL Server 2008 R2

如果你在安裝Visual Studio 2010一時手快，把MS SQL Server 2008 Express SP1給安裝進去，不用怕，升級的過程相關簡單：

1. 下載MS SQL Server 2008 R2
2. 在「安裝」選擇第二項「從SQL Server 2000、SQL Server 2005或SQL Server 2008升級」
3. 依畫面按下一步，升級完成

升級前版本：

Microsoft SQL Server 2008 R2 Setup Discovery Report

Product	Instance	Instance ID	Feature	Language	Edition	Version	Clustered
Sql Server 2008	SQLEXPRESS	MSSQL10.SQLEXPRESS	Database Engine Services	1033	Express Edition	10.1.2531.0	否
Sql Server 2008	SQLEXPRESS	MSSQL10.SQLEXPRESS	Database Engine Services	1028	Express Edition	10.1.2531.0	否
Sql Server 2008	SQLEXPRESS	MSSQL10.SQLEXPRESS	SQL Server 複寫	1033	Express Edition	10.1.2531.0	否
Sql Server 2008	SQLEXPRESS	MSSQL10.SQLEXPRESS	SQL Server 複寫	1028	Express Edition	10.1.2531.0	否

升級後版本：

Microsoft SQL Server 2008 R2 Setup Discovery Report

Product	Instance	Instance ID	Feature	Language	Edition	Version	Clustered
Microsoft SQL Server 2008 R2	SQLEXPRESS	MSSQL10_50.SQLEXPRESS	Database Engine Services	1033	Express Edition	10.50.1600.1	否
Microsoft SQL Server 2008 R2	SQLEXPRESS	MSSQL10_50.SQLEXPRESS	Database Engine Services	1028	Express Edition	10.50.1600.1	否
Microsoft SQL Server 2008 R2	SQLEXPRESS	MSSQL10_50.SQLEXPRESS	SQL Server 複寫	1033	Express Edition	10.50.1600.1	否
Microsoft SQL Server 2008 R2	SQLEXPRESS	MSSQL10_50.SQLEXPRESS	SQL Server 複寫	1028	Express Edition	10.50.1600.1	否

以上可以從SQL Server 安裝中心「工具」「已安裝的SQL Server功能探索報告」產生。主要是版本號，SQL Server 2008是10.1，SQL Server 2008 R2是10.5，10.5才是R2的版本。

Reference：

• MSSQL