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?


more ▼

asked Sep 09, 2010 at 08:12 AM in Default

avatar image

4.9k 33 39 43

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

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

more ▼

answered Sep 09, 2010 at 08:29 AM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

Sep 09, 2010 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, 2010 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, 2010 at 01:38 PM DaniSQL
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 09, 2010 at 08:12 AM

Seen: 1331 times

Last Updated: Sep 09, 2010 at 08:12 AM

Copyright 2018 Redgate Software. Privacy Policy