Talking databases

[Nathan Lehman]

	Well, the real and test database do have the same tables,
fields, output formats, etc.  However, they do not have the same
records/data.  There are a couple instances where the data matches in
both databases.  These are the ones that need to see each other.  I just
need to be able to get one or two fields in the particular table from
both databases and probably put the values into some new fields I'll
have to create once I figure this out.

> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at bestweb.net]
> Sent: Monday, January 09, 2006 4:14 PM
> To: Nathan Lehman
> Cc: filepro-list at lists.celestial.com
> Subject: Re: Talking databases
> 
> Quoting Nathan Lehman (Mon, 9 Jan 2006 15:55:27 -0500):
> 
> >             Hello all.  Here's my situation: We have two databases,
one
> > real and one is for testing purposes (although the two databases do
run
> > on the same file server).  Is it possible to pass information
between
> > the two in real-time?
> > Now I know the perfect solution of the two databases being able to
look
> > up information from each other in real-time is probably not an
option.
> [...]
> > I guess the
> > easiest/only way I can think of is to export the data from both
> > databases and import them into the opposite databases.  This would
have
> > to be scheduled and wouldn't be real-time but it is the best I can
come
> > up with.  Any help/suggestions would be appreciated.
> 
> If these files are to contain the same data in real-time, what is
> the difference between the "real" one and the "test" one?
> 
> > Oh, by the way, we run filePro 5.0.14 on a novell server with lots
of
> > little windows 2000/xp clients.
> 
> If this were Unix, I was going to suggest simply symlinking the files.
> 
> Can you explain how the "real" and "test" files are different, yet are
> to contain the same data in real-time?
> 
> --
> KenBrody at BestWeb dot net        spamtrap:
<g8ymh8uf001 at sneakemail.com>
> http://www.hvcomputer.com
> http://www.fileProPlus.com