I've got the following scenario:

Two applications with their own database needs to be integrated on
some common basic data (let's say person data). When the ApplicationA
enters a new users, this user should also be available in
ApplicationB.

Using a replication method, I've completed the flow of data between
the databases, so that all tables are available in the database schema
for ApplicationB.

personA [id_person {int}, sur_name {varchar40}, last_name{varchar40}]
- table definition
personB [id {char10}, fullname{varchar60}, lastname{20}, surname{40}]
- table definition

What would be the best approach to share the data between the two
application?

1. Adjust (if possible) ApplicationB to use the personA table?
2. Use a interface table int_person which may be used to map and
distribute data between the tables
3. Other solutions???

On 2011-03-03, OSteine <osteine (AT) gmail (DOT) com> wrote:

I would look at using an updatable view with one of the applications
(or both) this is of course non-standard, and so details depend on
the database you are using.

--
⚂⚃ 100% natural