[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

synchronizing databases across two machines

Posted on 2011-04-25
2
Medium Priority
?
378 Views
Last Modified: 2012-05-11
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.
0
Comment
Question by:NewtonianB
  • 2
2 Comments
 
LVL 38

Expert Comment

by:wesly_chen
ID: 35464449
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
 
LVL 38

Accepted Solution

by:
wesly_chen earned 2000 total points
ID: 35464454
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

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
Learn several ways to interact with files and get file information from the bash shell. ls lists the contents of a directory: Using the -a flag displays hidden files: Using the -l flag formats the output in a long list: The file command gives us mor…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question