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?
asked Sep 09, 2010 at 08:12 AM in Default
If the two systems are working (ie not out of service) then 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.