SQL Database - Move Tables from one Database to Another
I was performing an installation of Business Objects 4.2 and the CMS and Audit databases were created. However, not sure what I did, but the audit tables ended up in the CMS Table. Is there an easy way to move them out of CMS DB to the Audit DB without damaging pointers etc?
In the CMC I have the db connection pointed to the Audit db, but the tables are in the CMS db. I need to move them over to Audit db.