We help IT Professionals succeed at work.
Get Started

Delphi/VB, Paradox/other DB applications over WAN, Multi-site synchronisation

Actia
Actia asked
on
542 Views
Last Modified: 2010-04-05
I have a multi-user paradox database application that works over existing LAN connection.
~10 users, 12 tables, 100Kb - 10Mb per table, Delphi & VB applications.
Client now wants WAN support, over multiple site using their existing 1MBit WAN connection.

In a nutshell - What is the best way to achieve this?
- I know multi-user Paradox over WAN is really pushing it (should i start panicking now?)
- The application stores "real-time" information, so ideally information needs to be
  synchronised "on-the-fly".
- I was thinking some sort of synchronisation method to mirror database changes between sites.
- Does anyone have any data on Paradox file mechanism / bandwidth usage?
  Eg. If I append a single record to a remote 10Mb file, does it first read the entire file back & then
  append?
- I am presuming re-writing all applications to use a true Client-Server (different) DB would
  be a big job.
  Is there a 3rd party Client-server driver that can be bolted on to Paradox?
  Can FireFox / other royalty-free Client-Server DB quickly replace Paradox implementation?
- If anyone has any experience / solutions of this scenario I would be most grateful.
- Anyone still writing multi-user applications with Paradox?

Background:
* Database  on server PC, with local VB and delphi service applications read/write data to DB.
* Delphi client applications read data from DB.
* Delphi Database transactions performed using TQuery SQL
* VB Database transactions performed using ADO SQL
* All tables have primary index, simple fields (No maintained secondary indexes / other frills)
* Database integrity monitored with TUTIL32.dll
* Database backup performed with DbiCopyTable calls etc.

Thanks for your comments in advance,
Jay.
Comment
Watch Question
This problem has been solved!
Unlock 4 Answers and 9 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE