Hi,
We’re trying to move our Business Objects 6.5 sql server database from one server to another. We have the database created on the new server, db users created, etc. Next step is to shutdown the old Business Objects database and repoint Business Objects to use the new sql server database location. Has anyone had experience with this, or can tell where to configure Business Objects 6.5 to use the new database location versus the old server. Any help would be greatly appreciated.
Thanks
Here was the solution in case anyone else needs this…not sure if I was specific enough in my question:
Found it here:
Moving a repository is fairly simple and straight forward, but you do need to make sure that you follow all the steps.
It is recommended that you disable access to the repository before doing this. You can use a Timestamp for this purpose.
First of all, copy your repository database to its new location.
Open Supervisor, and on the Login screen, click on the Admin button, and follow the wizard to do a Safe Recovery. This will generate a new .key file. Note: The .key file only contains the pointer to the security domain.
Continue to login to Supervisor, and go to Tools - Repository. Select your Document Domain, and click edit. Change the connection to point to the new repository location. Do the same for the Universe Domain. Repeat this process for any and all document and universe domains. Very important!
Distribute your new .key file to all machines that access the repository. This includes your Webi server, BCA server, and all Full Client desktop machines.
That’s it. You can now shut down your old repository.