迁移BI项目以支持sql server 2012 [英] Migrated BI projects to support sql server 2012

问题描述

我已经迁移了BI项目以支持sql server 2012.但现在它不能在sql server 2008上运行。这是紧急的项目需求。请帮助。

Hi,

I have Migrated BI projects to support sql server 2012. But now it's not working on sql server 2008. This is urgent project need. Please help.

推荐答案

如果您更改了SQL以使用SS2012构造，那么解决它的唯一方法就是更改它们。



但在我看来，你正试图将SS2012备份部署到SS2008。这也行不通。您可以使用共享服务器连接来编写SQL以将一个DB的内容泵送到另一个DB，或者购买一个可以为您执行此操作的工具。

If you changed your SQL to use SS2012 constructs, then the only way to fix it, is to change them back.

But it looks to me like you're trying to deploy a SS2012 backup to SS2008. This also won't work. You can use a shared server connection to write SQL to pump the contents of one DB to another, or buy a tool that will do it for you.

这篇关于迁移BI项目以支持sql server 2012的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！