5

Limit cube downtime by doing automated rename of OLAP database

A suggestion from a partner:

It could be a very useful for customers that are not using enterprise edition of SQL Server if timeXtender could support automated renaming of the OLAP database after executing the project. 

The flow would be:

Manual deployment of the OLAP database A

Execution of the OLAP database A

Manual rename of the OLAP database A to B

Manual deployment of the OLAP database A

Users connect to OLAP database B for their reporting.

Scheduled execution of OLAP database A

Automated Rename of OLAP database B to C

Automated Rename of OLAP database A to B

Automated Rename of OLAP database C to A

End-users connecting to OLAP database B will experience very little downtime on the cubes.

0 comments

Please sign in to leave a comment.