在Azure VM上将SSAS迁移到AAS时遇到的问题,可以轻松回滚 [英] Issues migrating SSAS on Azure VM to AAS with a way to easily rollback

查看:273
本文介绍了在Azure VM上将SSAS迁移到AAS时遇到的问题,可以轻松回滚的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

大家好,我们一直在尝试将SQL Server SSAS服务器迁移到AAS实例,发现在管理实际迁移方面存在许多问题

Hi guys, we have been trying to migrate our SQL server SSAS server to an AAS instance and have found a number of issues with managing the actual migration

我们有许多Excel和PowerBI.com客户端可查询我们的多维数据集.每个组织中都有数百个分散对象

We have a number of Excel and PowerBI.com clients that query our Cube. There are hundreds of each scattered across the organisation

在转换阶段,我们希望有一种方法可以返回到旧的多维数据集.可能是我们遇到了重大的性能问题或其他问题,如果我们发现需要的话,也许不太可能值得一试.

During the changover phase we want to have a way to go back to the old Cube. It might be that we hit significant performance issues or other problems that while perhaps unlikely are worth having a way of going back if we find we need it.

我们认为我们可以使用此处描述的link://协议来做到这一点,https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-server-alias似乎这仅支持aas作为重定向路径.

We thought that we could do this using the link:// protocol as described here https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-server-alias however it seems that this only supports aas as the redirection path.

有什么办法可以做到这一点?

Is there any way to achieve this?

问题在于,我们将必须让所有报表用户更改其连接才能转到AAS,但是如果我们现在需要回滚,则需要联系他们并将其重新更改.当然必须有更好的方法吗?

The problem is that we will have to get all the report users to change their connection to go to AAS but then if we need to rollback right now we would need to contact them all and get them to change it back. Surely there must be a better way?

感谢您的任何想法.

推荐答案

嗨布雷特,

在这里看看这可能对您有用:

Take a look here this might work for you:

https://www.artisconsulting.com/blogs/greggalloway/2018/5/11/sending-users-to-the-geographically-nearest-azure-analysis-services


这篇关于在Azure VM上将SSAS迁移到AAS时遇到的问题,可以轻松回滚的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆