Planning Analytics

 View Only

 Renaming Databases

George Williams's profile image
George Williams posted Thu May 29, 2025 01:03 PM

Hi Team,

We have built some books that point a TM1 data server that has been suffixed with Prototype on the name.
I'd like to rename this server without breaking my views now that we are turning it into the main server.

Looking online this can be done on cloud from Administration > Databases page:
Rename a database

We are running PAW local so I can change the server name from the data server config but this will break my books.

The only way I can think is to change these is via the API... but it seems there must be a better solution than that?

Appreciate any help I can get.

Declan Rodger's profile image
Declan Rodger IBM Champion

What sort of "books" are we talking about?

If they are PAW Books you can open each one and press "CTRL + Q + /" which will bring up the board specification; you can then copy and paste that to notepad and do a replace all. Then just paste the updated code back in and press "Update".

If they are books in Excel it depends a bit on what type of reports you are using?

Emil Malmberg Fosdal's profile image
Emil Malmberg Fosdal IBM Champion

Hi George,

If you use lifecycle manager and make a snapshot of the books, you can import that and when importing you can change the server name (e.g., from dev_sales to prod_sales). 

In the newer versions of PAW (I believe from fall last year) you can then move in the books in the old location and overwrite the existing books.

That is how we handle it when moving from a dev to a prod named server.