Subject | Re: [Firebird-general] Syncrnizing Databases |
---|---|
Author | Sam D Hunt |
Post date | 2017-11-21T03:34:11Z |
are you customers needing to synchronize their local PC
databases, so all (local PC) customers will contain the same
data? Sounds like you might need Borland/Embarcadero Datasnap. I
own a BDS 2006 Architect license, but tired of the Windows
requirements to make Datasnap work.
so...I created my own distributed internet application "framework" (sorta - no middle tier) to replace Datasnap. My system employs a ComponentAce Absolute (single-user) database on the client side and a 2.5x FB database on the server side. Any number of clients (not restricted by FB) can share the same FB database across the internet and the clients are never bothered with state of their multi-user internet database.
The beauty of my approach is that the client app does NOT run in
a browser. It's a regular "Windows" EXE and the remote FB
database is served with a custom application server, NOT a web
server. I do this with just Delphi XE2 and Indy 10 TCPIP clients
and servers. And, my distributed internet system can scale down
to the LAN, or even a single PC user and uses exactly the same
code.
This may sound impossible, so I am willing to demonstrate my system to your employer from my home office free of any obligation.
I can also provide an on site demonstration.
My code may be licensed and I am available to serve as consultant for your employer.
Sam Hunt
auburn, wa
My company uses FB 1.56 (mostly embedded) and am needing a solution for synchronizing DBs. I'm a little confused as I hear that replication is one way and synchronization is two way, yet IBReplicator (by IBPhoenix) does synchronization (but its name would suggest otherwise).
Can anyone recommend a DB sync tool that my clients can use? It has to be simple for the end user. We can define the database structure and how to do the comparing--that is not something they would want to do.
Much appreciated,
Ed Dressel