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.jen...@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 > -- gor...@gmail.com Mob: 070-5530148