By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

How to migrate the SQL server SSAS to AWS RDS SQL Server

0

We are planning to migrate the SSAS services to RDS SQL server.

What are things we need to consider before decide the target( EC2/RDS) How to migrate the SSAS services to RDS SQL Server 2019/2022.

I found https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.Options.SSAS.html#SSAS.Deploy but this is explaining the new ssas only how to migrate the existing SSAS to AWS.

Thanks, Sanjeev

Topics
DatabaseMigration & ModernizationAnalytics
Tags
Microsoft SQL ServerGeneral Database MigrationsAmazon Relational Database ServiceDatabaseAmazon RDS for SQL Server
Language
English
Sanjeev_Reddy
asked 8 months ago508 views
1 Answer
0

Whether you decide to use SQL Server on EC2 or RDS I you can use SQL Server Management Studio (SSMS) to backup the SSAS database on the source server and then transfer that backup to ec2 or RDS via s3.

Microsoft has some good instructions here on migrating SSAS to a new server: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/upgrade-analysis-services?view=sql-server-ver15#side-by-side-upgrade

Note: the difference with SSAS running on RDS SQL Server is that instead of using SSMS to restore the database you will need to use RDS specific stored procedures:

e.g. exec msdb.dbo.rds_msbi_task

Here is a good blog with details on backup and restoring an SSAS database on RDS: https://aws.amazon.com/blogs/database/configuring-microsoft-sql-server-analysis-services-on-amazon-rds-for-sql-server/

profile pictureAWS
Alan-Cranfield-aws
answered 8 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content