Merging two data bases, each share a unique identifier.

[seth.levi]

I'm guessing that this is simple to do:

I have two databases, about 600,000 records in each, with data about
the same person in each, which need to be merged. The unique
identifier for each person is the same in both databases (well,
there's a 90% chance of this, see below). All I need to do is add a
few of the columns from database B into database A. Note: Database B
has more recent information than database A (and that information I
want to add to my already existing database). If someone is in A but
not B, then I want to purge the record (so if a record is not in the
newer database, I do not care about the person anymore). If they are
in B but not A, I want to keep it (since they are a new addition).
Does anyone have a walk through on how to do this?

I have not received the second database yet, so there is a chance that
the unique identifiers do not match up. However, each person's first
and last names, and date of birth are definitely identical in each
database. I assume that should be sufficient to match up records with
their counterpart in the other database.

Thanks

 

[seth.levi]

I'm guessing that this is simple to do:

I have two databases, about 600,000 records in each, with data about
the same person in each, which need to be merged. The unique
identifier for each person is the same in both databases (well,
there's a 90% chance of this, see below). All I need to do is add a
few of the columns from database B into database A. Note: Database B
has more recent information than database A (and that information I
want to add to my already existing database). If someone is in A but
not B, then I want to purge the record (so if a record is not in the
newer database, I do not care about the person anymore). If they are
in B but not A, I want to keep it (since they are a new addition).
Does anyone have a walk through on how to do this?

I have not received the second database yet, so there is a chance that
the unique identifiers do not match up. However, each person's first
and last names, and date of birth are definitely identical in each
database. I assume that should be sufficient to match up records with
their counterpart in the other database.

Thanks

This is basically what I'm trying to do:

http://groups.google.com/group/micr...139d370f1a4/513e33d423e9e3ac#513e33d423e9e3ac

But with the extra step of dealing with some people not being in both
databases.