By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,351 Members | 1,239 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,351 IT Pros & Developers. It's quick & easy.

Two way syncronizing with a website database with a local database

P: n/a
D0c
Hey,
I would like to syncronize my local database with my website database.
Scenarios are
1. New rows / row updates in the local database to be updated on the
website database (local -net)
2. Updates on the website database to be updated on the local database
(net -local)

* Updates for both databases are possibly on different fields

I am thinking of writing an application (C#.Net or what ever works)
that will start up the sync process (1 then 2 ).. maybe at the end of
a work day. The idea is to have a sort of replication of the database
both locally and internet. This is because, the local (client) may not
always be connected and could be disconnected for any length of time.
However once connection is restored,i would like for the sync process
to execute and sync both databases.

The underlining idea behind the website database, is for field updates
and viewing only. The local database is for new rows and field
updates.

My questions are,
1. Does MySQL provide scripting for such a sync as described above to
take place without overwriting data on either database?
2. If so can this sync be automated or executed with one click/
command ?

Feb 4 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.