Merge databases
Posted: Thu 14 May 2015 18:36
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
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