Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I inherited a project which has its data spread over 300 tables in 34 databases. After a first sweep i removed about 80 unused tables.

I would also like to merge the remaining tables in a single database, including the Foreign keys which are also 'Cross Database'.

Is there a recommend way to do this? I thought about editing the database dump, but that seems a bit tedious.

share|improve this question
1  
you mean the cross db fk are virtual right? How do you know the integrity constraints are respected? I think you should first do these checks since anyway you will have to do them. But if you do them earlyer that's less data to migrate – Sebas Jun 25 '12 at 13:18
I've tested the constarints and they were o.k. I wrote me a sed scricpt to modify the database dump which was not so tedoius as i was afraid of. Thanks for your help anyway. – Andre Jun 27 '12 at 4:54

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.