Tag Archives: database

How To Merge Two Databases (Update)

After matching/merging my people I found that many people had NUMEROUS Residence facts and these facts were linked with census records that weren’t even closely related to the location or people that they were attached to. Oh my! After further investigation I figured out that there was one record for each census year that held all of these links. This was not what I expected but I figured out how to fix it.

  1. Open the source citation and copy the place and ‘record for…’ info over to a text file so that you can easily find the source citation.
  2. Go to Sources, find the source citation (using the info you copied to the text file) and delete the source citation.
  3. Recreate the source citation for the family you just deleted.
  4. Merge all of the remaining facts – this is going to take even more time. ARGH!

I am also going through each of my Ancestry Sources to make sure that they aren’t old. When I open the source citation it should have a link in the bottom left-hand corner that says ‘View Source Online’. If it doesn’t have this then I rerun the search/merge so that the source citation is current and saved in the correct place.

Note: This process took a lot longer than I thought it would. I’m not sure if I will do it again.

Recommendation: I recommend that you don’t merge the sources when merging people. Run your own sources – it’s cleaner.

Tagged , , , , , ,

How To Merge Two Databases

Merging databases is a pain but it can be beneficial though to merge sources, pictures, and data that you might not have. Today, as part of my spring cleaning I checked out a database that I had downloaded quite awhile back when I was first using Ancestry online. I was surprised to find so much new info – a merge was definitely in order.

  1. Decide if you really want to do this. It takes a LOT of time and determination.
  2. Backup and backup again.
  3. I put all my surnames in all caps in my database. I recommend that you make sure the other database does NOT use surnames in all caps.
  4. Open the database you want to merge into. Select File>Merge from the toolbar. I do not recommend letting FTM match records for you. It’s best to do them yourself. Refer to FTM Help if needed.
  5. After the merge I don’t like to use the ‘Find Duplicate People’ because there are so many to match. I figured out that I can go down my list of people in the Person Workspace>Tree View and look for the lowercase surnames. When I find one I locate the matching name with the surname in caps and select it. Then I click the down arrow next to the People button and ‘Merge Two Specific People’. It should now be easy to find the lower-case-surname match and then carefully merge the two records. When you select the people from your database first they will be on the left side when the merge window opens and their facts should be listed as primary which should make matching easier.
  6. Continue down the list…
  7. When you are done you can then delete the old database. You will want to go through the sources and clean those up as well. I noticed that a lot of the images were not named correctly. More spring cleaning to do…

Hope this is helpful!

Note: See update.

Tagged , , , , ,