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

asked Sep 09 '10 at 08:12 AM in Default

DaniSQL
4.8k ● 30 ● 35 ● 39

(comments are locked)

1 answer:

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

answered Sep 09 '10 at 08:29 AM

Fatherjack ♦♦
38.8k ● 55 ● 69 ● 104

1 - @Fatherjack can I be a friend of Redgate too ;-)

Sep 09 '10 at 09:16 AM sp_lock

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?

Sep 09 '10 at 10:23 AM DaniSQL

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.

Sep 24 '10 at 01:38 PM DaniSQL

(comments are locked)