且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

Visual Studio 2013是否与SQL Server 2012兼容?

更新时间:2023-02-03 19:27:07

否,在Visual Studio 2015之前,您必须安装特定版本的Visual Studio才能定位特定版本的SQL Server.

No, prior to Visual Studio 2015, you had to install a specific version of Visual Studio in order to target a specific version of SQL Server.

  • Visual Studio 2008到SQL Server(2008、2008 R2)

  • Visual Studio 2008 to SQL Server (2008, 2008 R2)

从Visual Studio 2012到SQL Server 2012

Visual Studio 2012 to SQL Server 2012

Visual Studio 2013到SQL Server 2014

Visual Studio 2013 to SQL Server 2014

Visual Studio 2015到SQL Server(2012、2014、2016)

Visual Studio 2015 to SQL Server (2012, 2014, 2016)

Visual Studio 2017到SQL Server( 2012 ,2014、2016、2017, 2019 )*

Visual Studio 2017 to SQL Server (2012, 2014, 2016, 2017, 2019)*

因此,您需要使用Visual Studio版本2012、2015或2017 *来定位SQL Server2012.VisualStudio 2013仅与SQL Server 2014兼容.

So, you need to use Visual Studio versions 2012, 2015, or 2017* to target SQL Server 2012. Visual Studio 2013 is only compatible with SQL Server 2014.

Microsoft从Visual Studio 2015开始,引入了SQL Server定位的概念,该概念使您无需安装特定版本的Visual Studio即可针对各种SQL Server版本进行开发.因此,您可以在Visual Studio 2015中定位SQL Server2012.请参阅以下链接在Visual Studio中定位SQL Server: https://blogs.msdn.microsoft.com/sqlgardner/2016/08/17/ssdt-vs2015-gotcha-目标服务器版本新功能/

Starting with Visual Studio 2015, Microsoft introduced the concept of SQL Server targeting, which allowed you to develop for various SQL Server versions without having to install a specific version of Visual Studio. So, you can target SQL Server 2012 in Visual Studio 2015. See the following link for SQL Server Targeting in Visual Studio: https://blogs.msdn.microsoft.com/sqlgardner/2016/08/17/ssdt-vs2015-gotcha-target-server-version-new-feature/

*注意:自SSDT 15.8.1起,Visual Studio 2017添加了对SQL Server 2019的支持,同时删除了对SQL Server 2012的支持.如果需要在Visual Studio 2017中定位SQL Server 2012,则需要使用一个版本15.8.1之前的SSDT.在此处查看更改日志:

*Note: As of SSDT 15.8.1, Visual Studio 2017 added support for SQL Server 2019 while removing support for SQL Server 2012. If you need to target SQL Server 2012 in Visual Studio 2017, you will need to use a version of SSDT prior to 15.8.1. See the change log here: https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt?view=sql-server-2017

请注意此时使用SQL Server 2012,因为Microsoft正在逐步淘汰它.实际上,我会犹豫使用2014,并会认真考虑使用2016或2017.注意:SQL Server 2019是即将发布的下一个版本.

Beware of using SQL Server 2012 at this point as Microsoft is slowly phasing it out. In fact, I would be hesitant to use 2014 and would seriously consider going to either 2016 or 2017. Note: SQL Server 2019 is the next version that is coming out.