The project is about merging two separate databases. Each database holds images related to my clients and created by the same software at two separate offices. I am planning to merge these two databases and put them in one server. The challenge is, there are lots of overlaps where a client was going to both locations.
The software created different ID's at each location for the same client. As a result, client John Smith ID is 1225 at one location and 1145 at the other. The database is organized by client ID which is usually 4 digit. For example Client John Smith(ID 1100 is under Folder 1, sub-folder 2, sub-folder 2 and sub-folder 5.
The merge should be based on the name rather than the client ID and fortunately there are not so many clients with exact first and last name.