I have two servers that need to replicate their databases in near realtime. One is running Firebird, the other MS SQL server. I will need some sort of TCP/IP transciever and replicator agent to run every 5 seconds or so to replicate approx 10 fields including a BLOB (PDF) to send to an identical set of fields on SQL server. Both servers are in one facility and are on the same subnet. [url removed, login to view] should have a transmit and recieve TCP/IP and port entry. Should be able to run on server running Firebird (open source db), access db, take 20 fields and transmit to SQL server @ [url removed, login to view] port 3025 (for example). Needs to run every x seconds (selectable). Would be nice to be able to enter the field name of each of the fields but could also just be hardcoded field 1-20 as well.
Should be able to test over the internet. 50% down, 50% upon test completion