Merge data from two databases

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.com
Mob: 070-5530148