ptownbro (12/10/2016)
We have a new server and want to move the SSAS databases from the old server to the new one. I thought this could be done by detaching the db on the old server, copy db files to new server, and then attach db on new server. However, when I try to detach I get the following error:The ‘Attach/Detach functionality’ feature is not included in the ’64 Bit Standard’ edition of Analysis Services
I've reviewed a few ohther sources with people having similar problem. Most said this is only available with Enterprsie edition. We are using SQL Server 2012 Standard.
Couple questions:
1) Is this true? Can you not detach/attach with standard?
2) If you can detach/attach with standard, how can I do this?
3) If you cannot, how do you suggest moving the databases?
Question, why not simply backup-restore-drop old?
😎