Re: Distributed databases best practices

Approach can be used as a front-end to Oracle. I have many Approach apps with Oracle as the back-end. You will be able to migrate your existing apps fairly easily. The only real stumbling blocks are memo and picture plus fields, and if you haven't used them, your pretty much home free. One other minor issue is sequence numbers, but that's easy to re-create.

"John Hunter" <carlton_fisk72_at_hotmail.com> wrote in message news:0o0Q8.9013$f52.1248071_at_news-nb00s0.nbnet.nb.ca...
> Please excuse if I'm in the wrong group...
>
> We are currently doing a feasibility study on changing one of our systems
> from a lotus approach/dbase system to oracle 8i with a VB or web front
end.
>
> We are leaning towards a client /server interface because of it's
richness,
> but then again a web interface would be easier to deploy and would allow
> quicker response time to the database.
>
> The current system is located at 4 different centres across the country,
> without any direct network connection amongst them.
>
> I would like to see one central data repository, but am worried about
> connection and data retrieval speeds.
>
> We do need the ability to get financial information daily from all 4
> locations and it would be nice to have the ability to sincronize core
table
> data (item table, vendor table etc...)
>
> I'm looking for good information (white papers, perhaps) on this subject,
I
> have tried google and came up with a few ok articles, but am wondering if
> anyone here could enlighten me on their trials and tribulations.
>
> Thanks alot,
> -John
>
>
Received on Wed Jun 19 2002 - 11:15:36 CDT