我可以使用 SQL Server 2012 express 使用 SSDT/BIDS/SSIS 吗? [英] can I use SSDT/BIDS/SSIS using SQL Server 2012 express?

问题描述

理想情况下，我想在我的台式 PC 上制作 SSDT/SSIS 包，我可以测试并部署到生产服务器环境.在我的电脑上，我有:Windows 7的视觉工作室 2008Visual Studio 2010(外壳)SQL Server Express 2012(产品的本地开发副本)[据说] BIDS (Business Intelligence Development Studio) 和 SSDT (SQL Server Data Tools) 等

Ideally, I want to make SSDT/SSIS packages on my desktop PC that I can test and deploy to a production server environment. On my PC I have: Windows 7 Visual Studio 2008 Visual Studio 2010 (shell) SQL Server Express 2012 (local dev copy of prod) [supposedly] BIDS (Business Intelligence Development Studio) and SSDT (SQL SErver Data Tools) etc.

在我的生产服务器上，我有:视窗服务器 2008SQL Server 2012Visual Studio 2010(外壳)

On my production server I have: Windows Server 2008 SQL Server 2012 Visual Studio 2010 (shell)

我无法在我的机器上加载/运行 SSIS(SQL Server 集成服务)，因为 SQL Server express 不允许，正如这些文章所建议的:

I cannot load/run SSIS (SQL Server Integration Services) onto my machine because SQL Server express doesn't allow for it, as suggested by these articles:

http://support.microsoft.com/Default.aspx?id=963070

http://msdn.microsoft.com/en-us/图书馆/cc645993.aspx#SSIS

当我尝试查看 VS 中的package.dtsx"文件时出现此错误:

And I am getting this error when trying to look at a "package.dtsx" file in VS:

Microsoft Visual Studio 无法加载此文档:要设计SQL Server Data Tools (SSDT) 中的 Integration Services 包.固态硬盘必须由以下 SQL Server 2012 版本之一安装:标准.企业.开发人员或评估.要安装 SSDT，请运行SQL Server 安装程序并选择 SQL Server Data Tools.

Microsoft Visual Studio is unable to load this document: To design Integration Services packages in SQL Server Data Tools (SSDT). SSDT has to be installed by one of these editions of SQL Server 2012: Standard. Enterprise. Developer, or Evaluation. To install SSDT, run SQL Server Setup and select SQL Server Data Tools.

当我运行 SQL2012Express 安装程序时，它说 SSDT 已经安装.

When I run the SQL2012Express installer, it says SSDT is installed already.

问题#1:但为什么我不能在我的生产 SQL2012 环境中直接指向本地 VS2010/SSDT/SQL2012Express?(微软正在合法地获得他们的钱！)

Question #1: But why can't I just point a local VS2010/SSDT/SQL2012Express at my production SQL2012 environment? (Microsoft is getting their money legitimately!)

问题#2:我可以让它在生产服务器上工作，但在生产服务器上开发不是很糟糕吗?(并且它使源代码控制等复杂化)

Question #2: I can get it to work on the production server, but isn't it bad form to develop on a production server? (and it complicates source control etc.)

推荐答案

您必须安装这些版本之一.带有高级工具的 SQL Server Express 版本仅包含报告.不是姐姐.Sql serverv 开发版实际上很便宜.

You must have One of those versions installed. The SQL server express edition with advanced tools only includes reporting. Not ssis. Sql serverv dev edition is actually pretty cheap.

这篇关于我可以使用 SQL Server 2012 express 使用 SSDT/BIDS/SSIS 吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！