Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Advantages of using 1 or 3 database containers
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00254345
Message ID:
00254373
Views:
27
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
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform