Merge databases

[Staggan]

Hello

I have multiple copies of a database schema, all with separate data...

I now want to merge all of this data into one location...

I have prepared all the individual databases so there is no clash of any unique ID's etc... but I cannot find anything that will allow me to append the data from one database to the other...

For example..

I have a table called user and another called purchases... this table exists in each database... But now I want to merge that data into a single place...

I have tried numerous ways to do this but I only ever seem to end up with the data from the last database I tried to merge...

Also, when I try to append the data I get an error about one of the tables, a table that does not exist in the schema..

Can anyone help?

Thanks

[alexa]

Since this issue is not connected specifically with dbForge, we recommend you to refer to some other sources in the Internet for help.