Visual Studio(SSDT BIDS) for SQL Server

  • Article

Visual Studio(SSDT BIDS) for SQL Server

SSDT: SQL Server Data Tool

BIDS: Business Intelligence Development Studio

SQL Server Visual Studio Version
SQL Server 2005 透過SQL Server安裝程式勾選安裝Visual Studio 2005 8.0.50727.42 (RTM.050727-4200)BIDS_VS2005_v8.0.50727.42
SQL Server 2008 透過SQL Server安裝程式勾選安裝Visual Studio 2008 9.0.30729.1 SPVisual Studio 2008含有SP1Actions that are required before you install SQL Server 2008 on a computer that has Visual Studio 2008 or the prerelease version of SQL Server 2008 installed https://support.microsoft.com/kb/956139/en-us BIDS_VS2008_v9.0.30729.1
SQL Server 2008 R2 透過SQL Server安裝程式勾選安裝Visual Studio 2008 9.0.30729.4462 QFEVisual Studio 2008含有SP1，但是畫面沒有SP字眼SQL Server Data Tools - 2012 年 12 月版的更新 SQL Server 2008所安裝的Visual Studio 2008含有SP1 https://support.microsoft.com/kb/956139/en-us BIDS_VS2008_v9.0.30729.4462如果在SQL 2008 R2安裝(含BIDS)完成之後，再安裝Visual Studio 2008 SP1也是可以安裝成功。最後安裝的結果如下:Exe (D:\vs90sp1\VC_x86Runtime.exe) succeeded.Log File: dd_VC_x86RuntimeMSI543A.txtLog File: dd_VC_x86RuntimeUI543A.txtExe (D:\vs90sp1\VC_x64Runtime.exe) succeeded.Log File: dd_VC_x64RuntimeMSI5447.txtLog File: dd_VC_x64RuntimeUI5447.txtD:\vs90sp1\VC_IA64Runtime.exe - Exe installer's log file/hint (%temp%\dd_VC_IA64Runtime*.txt|%temp%\..\dd_VC_IA64Runtime*.txt) does not exist or is invalid.Exe (D:\vs90sp1\VC_IA64Runtime.exe) succeeded.Patch (D:\vs90sp1\VS90sp1-KB945140-X86-ENU.msp) install succeeded on product (Microsoft Visual Studio 2008 Shell (integrated mode) - ENU). Msi Log: Microsoft Visual Studio 2008 SP1_20160902_092951310-Microsoft Visual Studio 2008 Shell (integrated mode) - ENU-MSP0.txtFinal Result: Installation completed successfully
SQL Server 2012 Visual Studio 2010 (SQL Server Data Tools) 10.0.40219.1 SP1Rel 含有Visual Studio 2010 SP1Visual Studio 2010 SSDT的更新 SQL Server Data Tools - 2012 年 12 月版的更新https://msdn.microsoft.com/zh-tw/data/jj650014 SSDT_VS2010_10.0.40219.1
SQL Server 2014 需自行下載2014-10-27 Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 https://www.microsoft.com/zh-tw/download/details.aspx?id=423132014-06-26 Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 https://www.microsoft.com/zh-tw/download/details.aspx?id=36843

 

Download SQL Server Data Tools (SSDT)
https://msdn.microsoft.com/en-us/library/mt204009.aspx