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.