Visual Studio 2013是否与SQL Server 2012兼容? [英] Is Visual Studio 2013 compatible with SQL Server 2012?

问题描述

我有一些使用SQL Server 2014在Visual Studio 2013(用于SQL Server的数据工具)中开发的SSIS软件包.应该将这些软件包移到运行SQL Server 2012的服务器上.

I have some SSIS Packages that were developed in (SQL Server Data Tools for) Visual Studio 2013 using SQL Server 2014. The packages are supposed to be moved to a server running SQL Server 2012.

在安装过程中，我们收到一条错误消息，指出软件包与SQL Server 2012不兼容.显然，Visual Studio 2013从SQL Server 2014到SQL Server 2012不向后兼容吗?但是，Visual Studio 2015是.

During the install we get an error that says the packages are not compitable with SQL Server 2012. Apparently Visual Studio 2013 is not backwards compatible from SQL Server 2014 to SQL Server 2012? But, Visual Studio 2015 is.

那么，是否必须在Visual Studio 2015中重写SSIS程序包才能与SQL Server 2012一起使用?还是有另一种方法可以使它工作而无需重写它们...

So, do the SSIS packages have to be rewritten in Visual Studio 2015 to work with SQL Server 2012? Or is there another way to make it work without rewriting them...

推荐答案

否，在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.

这篇关于Visual Studio 2013是否与SQL Server 2012兼容?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！