question

DaniSQL avatar image
DaniSQL asked

Business Objects Edge Series Setup Help

Hello, I posted this on serverfault and got no response so far and I thought I might try here as well I was setting up Business Objects edge series for the first time with an existing SQL Server CMS and Audit Database, but I forgot to create two separate system DNS and everything is created now on the CMS database. I have two questions: is cramming both the CMS and Audit database together a problem? If yes how do i split the audit database from the CMS database? Thanks
business-objects
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Fatherjack avatar image
Fatherjack answered
If the two systems are working (ie not out of service) then that isnt a problem. If the server is coping with the load then that isnt a problem. If the systems are responding within adequate times to keep the users happy that isnt a problem. If you want/need to split the database objects out then you will need to take the objects that support one system and script them into a new database. Personally I would use something like RedGate's SQL Compare to do the job. Other products are available and may suit your needs too. Disclosure: I am a Friend of RedGate, I like and use their products a lot. 2nd thoughts: You wont have a specific backup for either of the systems, if you need to restore then both systems may be affected. This is a point to make to the system manager(s) and get their decision/approval
3 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Forgot to share how I did it if it helps some one in the future: I created new Audit and CMS databases and a respective 32 bit ODBC System DSN's. Then you go to the CMC(central configuration manager), stop the Server Intelligence Agent, right click and choose the configuration tab and change the CMS system database configuration and the Audit Information data sources to your new DSN's. When you are done restart the server intelligence agent.
1 Like 1 ·
+ 1 - @Fatherjack can I be a friend of Redgate too ;-)
0 Likes 0 ·
Thanks @FatherJack. I have SQLcompare and I will use that to script the objects missing in the Audit database. Forgive me if this is a silly question, but how do I re-point the application to the new system DNS which is connecting to the audit database?
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.