Talking databases

[GCC Consulting]

-----Original Message-----
From: filepro-list-bounces at lists.celestial.com
[mailto:filepro-list-bounces at lists.celestial.com] On Behalf Of Nathan Lehman
Sent: Monday, January 09, 2006 5:16 PM
To: filepro-list at lists.celestial.com
Subject: RE: Talking databases

	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.

Two other Non "real Time" solutions come to mind.

1. Create an output file with only the fields you want matched in both
databases.  Output the records which need changing.  Copy the key to the
other database and run an export process to update the proper file.

2. Do the same using a qualifier

3. Create a CSV file and import it.

None of these are "real Time" solutions.   Check With Sue, the ODBC upgrade
may be worth it in the lone run if it keeps you from have to do this
manually.  Although you could automate the task using the task scheduler.

Richard Kreiss
GCC Consulting
 


> -----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

_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
http://mailman.celestial.com/mailman/listinfo/filepro-list