Re: 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(dot)jenner(at)autovhc(dot)co(dot)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(at)gmail(dot)com
Mob: 070-5530148