We help IT Professionals succeed at work.

SQL Database - Move Tables from one Database to Another

227 Views
Last Modified: 2017-04-11
Hello Experts,

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.

Thanks,
Pam
Comment
Watch Question

CERTIFIED EXPERT
Distinguished Expert 2019

Commented:
The create/copy on the db is one step, your application installation may have their own referencing that based on your responses combined though I am unfamiliar with the application you reference so it is hard to respond to the impact specifically if as many use stored procedures, viewers etc.
that will complicate severing.

If this is an initial install where there is not data, starting ...
IT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Vitor MontalvãoIT Engineer
CERTIFIED EXPERT
Distinguished Expert 2017

Commented:
Member_2_7964761, a feedback will be appreciated.
Cheers

Author

Commented:
Thanks!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions