Moving a cube to a different database can be accomplished in two different ways:
- You can edit each dataset and update the table reference to the new database.
- You can open the Project XML, search and replace the old database name with the new one.
NOTE: For both cases, you must republish the cube for the changes to take effect.