Yes this is possible. This is what the 'Data Synchronization' tool from the 'powertools' menu does.
Please start reading the relevant paragraph in the program help file (help .. help menu) and practice a little with two unimportant databases (they may both be on the same server) and feel free to ask more questions after that.