Solved

doing data replication with BDE

Posted on 2003-12-07
6
235 Views
Last Modified: 2013-11-23
Data replication is possible with high end databases or SQL servers.  But is there a possibility to achieve similar results in BDE ?  I want my user to modify various records onto two (or more) copies of a table in different locations.  Then once a day (or a week) bring all these copies in one of the location and do a synhronizing job where all records modified in one location get updated in the other and vice-versa.

Is this possible ? and how
0
Comment
Question by:fadyg
  • 2
  • 2
6 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 9894962
you must do this by hand,
using TBatchMove or if it does not fit you must code your own
Replication-routine

meikl ;-)
0
 

Author Comment

by:fadyg
ID: 9895150
Ouch !
To your knowledge, has anyone done any component or module that could do the job ?
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 9895265
what database will u use?
do u have a master-database?
0
 

Author Comment

by:fadyg
ID: 9895393
using paradox BDE. I must be able to work on any of the locations without considering one of the tables as a master.

It's a bit like the PALM pda where you can invariably work on the PDA itself or on the computer. Then, upon synchronizing, it will take the newest work of both sides and merge it inside the other side.  Of course an event could be fired if same record has changed on both locations after last update.
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 13056297
PAQed with points refunded (250)

modulo
Community Support Moderator
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question