I am trying to create two databases in two different machines connected over the lan. Both the databases have similar tables and fields in them. I will be updating database A always. I want the update to be backed up to database B automatically during the night when no one will be using the databases.
Can some one tell if if this can be done and if yes how ?