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.
GH
2010/5/28 Jamie Lawrence-Jenner
<jamie.jenner@autovhc.co.uk>Hi There
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
Many thanks
Jamie
--
gorhas@gmail.comMob: 070-5530148