Actually you have to write a program to insert one database into another. This is so the program can check for concistancy and maybe recect records or datasets that are inconsistent.
We have a stats databases which has been dumped out a few times over the last year.
What i would now like to do is to merge these dumps into one database. The problem is is that when the dumps were done, a drop and create was carried out on the database so primary key columns will collide
I have three dumpes, how do i merge the data into one database please