You have a SQL Server Analysis Services (SSAS) database named DB1 on a server named Server1.
You need to deploy DB1 from Server1 to four other servers. If the destination server already contains a copy of DB1, the database must be updated only. If the destination server does not contain a copy of DB1, the database must be copied to the destination server.
What is the best deployment option to use? More than one answer choice may achieve the goal.
Select the BEST answer.
A. Analysis Services Deployment Wizard
B. Analysis Management Objects (AMO) automation
C. Backup and Restore
D. Synchronize Database Wizard
