Import one into the other, which now contains all the data. Duplicate that file in the Finder if you need two files.

Geoff

From: FileMaker Pro Discussions [mailto:[log in to unmask]] On Behalf Of Roger Adams
Sent: Wednesday, July 06, 2016 12:36 AM
To: [log in to unmask]
Subject: Re: Merging two FM databases

Hi Jonathan,

Many thanks for the prompt response. I am the designer of the database although not a professional FM designer, merely a hobbyist.

Actually, both databases are the same on two different Macs with exactly the same fields but one contains data that the other does not and v.v.

What I am trying to do is to get them to be exactly the same. A pity that there is not an app to merge the two.

Is there an easier way to achieve this than going through the database record-by-record?

Again, I do appreciate your help.

Cheers

Roger



> On 6Jul, 2016 AD, at 11:11 AM, Jonathan Fletcher <[log in to unmask]> wrote:
>
> Copy and paste?
>
> You can copy the tables from one file into another and have both of them in one file. You then import the data from the external file.
>
> That said, if you simply want to merge the data into one table and there aren’t any duplicates, you can simply import from one to the other.
>
> If however there are data points that conflict or records with duplicate data or IDs then all bets are off, and you will need two people to complete the task:
>
> 1. Someone who knows the data intimately and how exactly you want it to end up
> 2. Someone who knows FileMaker pretty well
>
> From the wording of your question, I am assuming that you MAY be the former and are likely not the latter.
>
> There will not be an “app” that will make the same decisions that your brain would, if there is anything that actually requires a decision. (Believe me there will be more decisions than you have already thought of. Happens every time.)
>
> Jonathan
>
>
>
>
>> On Jul 5, 2016, at 11:12 PM, Roger Adams <[log in to unmask]> wrote:
>>
>> Hi Folks,
>>
>> I am looking for am app that will merge two FM databases. Is there such an app and if so, I would appreciate if you could advise where and how I can get it.
>>
>> Many thanks
>>
>> Roger
>
> --
> Jonathan Fletcher
> [log in to unmask]
>
> Kentuckiana FileMaker Developers Group
> Next Meeting: 7/26/16