synchronizing databases across two machines

I have a laptop and desktop development machine, I'm trying to always be in sync with both data in database and files.

I fixed my file issue by running unison scripts which works beautifully.
My issue is my database now. Is there any graceful way to handle that or do I need to dump and reinsert every time i want to refresh updates?
I'm using mysql server.
NewtonianBAsked:
Who is Participating?
 
wesly_chenConnect With a Mentor Commented:
Database synchronization need to be done on database level, not on filesystem level.
You can setup replication for Master and slave (one way, from master to slave),
Or the database dump and restore (not bad with small database ),
0
 
wesly_chenCommented:
Oracle Database Lite 10g Automatic Synchronization White Paper
http://www.oracle.com/technetwork/database/database-lite/backgroundsync-130778.pdf



Compare and synchronize Oracle databases with ease (commerical)
http://www.devart.com/dbforge/oracle/datacompare/?gclid=CLyBxMWpuagCFacZQgodbk9hBw
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.