I was able to backup and restore the iam_ont and sf database to the new server. However, I cannot seem to rename the iam_ont database. When I do, the application wants me to login to the 'old name' iam_ont. All logins fail because the 'old name' database no longer exists.
Is there a way to do this?
Best answer by Anne Buit
Can you run the following queries on the renamed IAM_ONT database:
where project_id = 'SQLSERVER_IAM'
from server s
join gui_appl g
on g.server_id = s.server_id
where g.project_id = 'SQLSERVER_IAM'
This returns the server and database for the IAM itself. These should always return current_server and current_database.
If these are correct, you should be able to access IAM and update the server and database of the Software Factory application accordingly.