Subject Re: [Firebird-general] Syncrnizing Databases
Author Sam D Hunt

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


On 11/20/2017 1:54 PM, dressel@... [Firebird-general] wrote:
 

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