Eddie,
IMHO, if you are merging data, then go with 1 DBC. Each DBC has to be loaded separately, and your code must always be aware which DBC is open. If you want information from more than one DBC then you will have to deal with cursors and temporary files.
If you are keeping each of the companies' data separate, then you might consider running your EXE in 3 areas with separate but identical DBCs for each area.
HTH
Barbara
>I am migrating applications from foxpro 2.6 and want to use the database container. Our organization is divided into three companies and their data has always been separate. I am working towards merging all of the data from the three companies.
>
>Can anyone tell me the advantages & disadvantages of having 3 database containers verses having only 1 database container.
>
>Thanks in Advance for your help,
>Sincerely,
>
>Eddie Caldwell