FiveTech Software tech support forums

... The convenience of DD is not appreciated unless you've used them. Having Data Integrity rules, User logins, Stored Procedures, Functions, Replication, etc... is all foreign to most xbase developers. Having files on a file system does not protect or keep data private and secured the way ...

... se encarga MARIADB automáticamente, y la actualización es instantánea Puedes ver algunas opciones acá https://mariadb.com/kb/en/setting-up-replication/ Saludos. PD: Lo único es que tu proveedor de hosting debería soportar la replicacion

Hello Mr. Rao, hello everyone else, and my apologies for being absent for so long; Let me suggest a different approach at achieving replication: 1. have a way to declare a "publication". A publication describes what tables & columns are to be replicated. A single database could ...

RAO 1 ) Ok , i check can you answer me for point 2 ? 2) I Try the function UpdateTableToServer( cTable, oDestServer, cTimeStampFld ) --> lSuccess I modify my table ans create a field TIMESTAMP ALTER TABLE arti ADD modificato_il TIMESTAMP ON UPDATE CURRENT_TIMESTAMP NOT NULL DEFAULT CURRENT_TIMEST...

... open. 2) When you open a table on the main server, you need to set oRs:oReplServer := <replserverconnection> The corresponding table on the replication server should be identical with the main table. Then any changes made to the main table will be replicated to the same table on the replication ...

Hello RAO 1) I am testing Table Replication Features. If I make changes in the xbrowse oRsMain all works ok . But if at the same time I make changes to the oRsMain table with another program or procedure the oRsRepl table it is not updated. ...

... cTable on current server. This is possible only if the table contains a timestamp field created with datatype "=". - FWMARIAROWSET TABLE REPLICATION: New Datas: oReplServer bOnReplFail If oRs:oReplServer is assigned with connection object to an external server, all modifications (modify,append ...

Dear Rao Sir , Good Idea Data Sync On TimeStamp Based ..! UpdateTableToServer( cTable, oDestServer, cTimeStampFld ) --> lSuccess Will Replication manage automatically, if Table Structure columns count is diff between source and target ? e.g. source table has extra column compare to ...

We request interested users of FWH 18.11 to put this feature to intensive test and provide feedback and suggestions to help us to improve this feature.

... the latest changes from the table on the current server. This is a faster way to update the destination table after failure or discontinuation of replication. Please note that it is easy to create such a timestamp field using datatype "=" using oCn:CreateTable() method instead of creating ...

can I replicate part of the BD, such as file with Name, address, phone, value, local database and remotely replicate the same database, with the same name, but only the name and value fields? thanks Not possible. Structures of both the table should be identical. Also, there should be an auto-increm...

Use

Code: Select all  Expand view

oMainCn:CopyTableToServer( cTable, oRemoteCn )
 

This will overwrite the remote table with the present table on the main server and makes both the tables identical.
The time taken depends on the size of the table.

can I replicate part of the BD, such as file with Name, address, phone, value, local database and remotely replicate the same database, with the same name, but only the name and value fields? thanks

Dear Rao Sir , Excellent feature...! If the write to replication server fails, the transaction is rolled back on the main server too. Thereby it is ensured that either the transaction is written to both servers or none at all. Any Function that does ...