- Sep 27, 2009
- 8
- 0
- 0
Hi everyone thanks for reading
I have inherited a problem, I need to merge these two databases but one is a single table and the other is a set of 3 tables.
First here is our database
http://imgur.com/jp0kp.png
Here is their database
http://imgur.com/OVZGB.jpg
How would you go about doing this? Their database uses the PARENT_MODEL column to tie makes and models together, is this an appropriate way that I should duplicate in our database?
Thanks for reading, Further down the road we'll probably pick up another chunk of information so I would like to get it right this time.
I have inherited a problem, I need to merge these two databases but one is a single table and the other is a set of 3 tables.
First here is our database
http://imgur.com/jp0kp.png
Here is their database
http://imgur.com/OVZGB.jpg
How would you go about doing this? Their database uses the PARENT_MODEL column to tie makes and models together, is this an appropriate way that I should duplicate in our database?
Thanks for reading, Further down the road we'll probably pick up another chunk of information so I would like to get it right this time.