Visual Studio 2013 是否与 SQL Server 2012 兼容?
我有一些使用 SQL Server 2014 在(SQL Server Data Tools for)Visual Studio 2013 中开发的 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)
https://docs.microsoft.com/en-us/sql/integration-services/install-windows/installing-integration-services-versions-side-by-side?view=sql-server-2017
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 Server 2012.Visual Studio 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.
从 Visual Studio 2015 开始，Microsoft 引入了 SQL Server 目标的概念，它允许您针对各种 SQL Server 版本进行开发，而无需安装特定版本的 Visual Studio.因此，您可以在 Visual Studio 2015 中定位 SQL Server 2012.有关 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.请参阅此处的更改日志:https://docs.microsoft.com/en-us/sql/ssdt/changelog-for-sql-server-data-tools-ssdt?view=sql-server-2017
*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.
相关文章