Обсуждение: Merge data from two databases

Поиск
Список
Период
Сортировка

Merge data from two databases

От
"Jamie Lawrence-Jenner"
Дата:

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

Re: Merge data from two databases

От
Goran Hasse
Дата:
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