data in client and server - synchronization

[ngterry]

Hi Red1!

Will the data be lost in client for no electricity if the client and server are not in the same machine? Because in my understanding the database is installed in server. How is the mechanism of the client-server synchronization? If there is no such mechanism, is there any solution?

Regards,

Terence

[afalcone]

Hi Terence,

Permit me to express him my point of view al regarding its consultation:

The data are kept in the team where is found lodged the database, by which if the team client remains without electricity, themselves no data is lost, since they are not in that team.
If you has saved you record (press the save button i.e., before being produced the cut of electricity), all those data are stored in the server, not in the client. Its machine client does not store data, but they are stored in the database server machine.

If on the contrary, loses the connection with the server, when you try to record its data will receive an error message that will indicate the impossibility to record its data. In that case will not be able to record them to so much can be connected again with the server.

If client machine is same as database server and is put out, should neither be lost data, therefore of it the same database is entrusted (note that al less oracle and sybase are transactional databases, what guarantees that the transactions are kept complete, not permitting that weaknesses they be generated, this is that be kept part of a transaction and another be not kept).

Best regards,

Alejandro

[ngterry]

Hi Alejandro,

Do you mean the client will write the data in the client's harddisk (the team) before transmitting to the server database? Therefore, the client has a data storage mechanism even no database installed. When the client is facing a cut of electricity, the data in the client will not be lost. Am I right?

Regards,

Terence

[afalcone]

[ngterry]

[afalcone]