Updating Data on Other Server?? [modified]

AmbiguousName

Hi guys...I do not know whether it is right platform to ask the question. Suppose I update databse on my laptop. Now I want the same database on another location, to be updated automatically...obviously wirelessly. How to do that??:confused:

modified on Monday, January 4, 2010 1:35 PM

Stryder_1 · modified on Monday, January 4, 2010 1:35 PM

Hi, It will likely depend on the database you are using. Also, is this connected at the same time, or do you mean to have the database on your laptop updated, then when you connect to the other location, it updates at that time? Two main ways: 1) Replication - Review this in your db documentation and return if you have further questions. 2) Do it yourself in code - code your app to send the changes when you connect the the remote database. Thanks.

Mycroft Holmes · modified on Monday, January 4, 2010 1:35 PM

What happens to the updates if your wifi connection is down? What happens when there are 2 or more local databases? This is a really bad design. If you are working offline (local database) then you need to implement a replication strategy. This involves more than just shoving data back and forth.

Never underestimate the power of human stupidity RAH

AmbiguousName

There is Server1, Server2..... Server2 is nearer than Server1 at some location, to my device. Server2 is selected and the changes are written to the database on it. Now after this, changes should be automatically written to the Server1......hope made it clear to you. Having said this I"ll use your first suggestion.....Replication

AmbiguousName

Ans#1: what happens if your nearest ATM is not working well. You will have to wait untill it is fixed. Ans#2: In case of 2 or more local DBs, nearest one will be selected to be updated. Apart from this...im a student so any stupidity is hopefully forgiven :)

Mycroft Holmes

Muzammil Saeed wrote:

Apart from this...im a student so any stupidity is hopefully forgiven

Absolutely This is not necessarily stupid, just part of the learning process, what sort of system are you trying to design you have completely confused me with ATM, wireless and nearest database.

Never underestimate the power of human stupidity RAH

AmbiguousName

There is Server1, Server2..... Server2 is nearer than Server1 at some location, to my device.Hence Server2 is selected and the changes are written to the database on it. Now after this, changes should be automatically written to the Server1......hope made it clear to you