Offline Synchronisation

People,

 Work have asked for the folowing application....

 We have a "salesman" who has a laptop, and is
out and about, connecting back 
to the office via VPN at irregular intervals, as well as
visiting the office.
 They want a DB of contacts, and for staff back here at
Admin to be able to 
use and update the DB. I have a .php & MySQL app thought
out - that's the 
simple part.

 I am thinking a DB on his machine, and another here at
Admin. I would need 
him to be able to Sync the two databases, so people here at
Admin can work 
with and update the data. When he syncs, his entries will
need to be 
populated to the Admin DB, and altered entries from people
here at Admin (in 
the Admin DB), to be sent back to his DB.

 So, is there a simple way to do this, or a MySQL addon, or
even a commercial 
product (price within reason) ?

 Any help much appreciated.

-- 
Mark Unwin
System Administrator
Queensland Police Credit Union


************************************************************
*************************************
This message and any attachments, or any part
of it is intended solely for the named addressee.  

Reading, printing, distribution, storing, commercialising
or acting on this transmission or any information it
contains, by anyone other than the addressee, is prohibited.
If you have received this message in error, please destroy
all copies and notify 
Qld Police Credit Union Ltd on +61 7 3008 4444 or by
replying to the sender.

This message may contain legally privileged and
confidential information, and/or copyright material
of QPCU or third parties.

QPCU is not responsible for any changes made
to a document other than those made by QPCU,
or for the effect of the changes on the document's meaning.
You should only re-transmit, distribute or commercialise
the material if you are authorised to do so.

Any views expressed in this message are
those of the individual sender.  You may not rely on this
message as advice unless subsequently confirmed by fax or
letter signed by an Officer or Director of QPCU, or 
an Authorised Representative QPCU.

QPCU advises that this e-mail and any attached files should
be scanned to detect viruses.  QPCU accepts no liability for
loss or damage (whether caused by negligence or not)
resulting from the use of any attached files.

Information regarding Privacy can be found at the QPCU web
site. ( www.qpcu.org.au )

General Advice Warning

Any advice has been prepared without taking into account
your particular objectives, financial situation or needs. 
For that reason, before acting on the advice you should
consider the appropriateness of the advice having regard to
your own objectives, financial situation and needs.  Where
the advice relates to the acquisition, or possible
acquisition, of a particular financial product, you should
obtain a Product Disclosure Statement relating to the
product and consider the Product Disclosure Statement before
making any decision about whether to acquire the product.
************************************************************
*************************************


-- 
Brisbane MySQL Users Group Mailing List
For list archives: http://lists.mysql
.com/ug-brisbane
To unsubscribe:    http://
lists.mysql.com/ug-brisbane?unsub=bondyahoo.com

Hi - I probably shouldn't say this on a MySQL email list
but Sybase had a
great solution to this about 10 years ago built into their
SQL Anywhere
product. They built their replication to be two-way from the
start and
allowed you to define trigger-like code to handle conflicts.
It was a neat
and useful solution to the problem.

Maybe you should try a commercial product - it might save
your company lots
of development money. I personally used the product in a
large Australian
3-tier replication product.

Cheers,

John


-----Original Message-----
From: Mark Unwin [mailto:munwinqpcu.org.au] 
Sent: Wednesday, 8 March 2006 2:08 PM
To: MySQL Users Group - Brisbane
Subject: Offline Synchronisation

People,

 Work have asked for the folowing application....

 We have a "salesman" who has a laptop, and is
out and about, connecting
back 
to the office via VPN at irregular intervals, as well as
visiting the
office.
 They want a DB of contacts, and for staff back here at
Admin to be able to 
use and update the DB. I have a .php & MySQL app thought
out - that's the 
simple part.

 I am thinking a DB on his machine, and another here at
Admin. I would need 
him to be able to Sync the two databases, so people here at
Admin can work 
with and update the data. When he syncs, his entries will
need to be 
populated to the Admin DB, and altered entries from people
here at Admin (in

the Admin DB), to be sent back to his DB.

 So, is there a simple way to do this, or a MySQL addon, or
even a
commercial 
product (price within reason) ?

 Any help much appreciated.

-- 
Mark Unwin
System Administrator
Queensland Police Credit Union


************************************************************
****************
*********************
This message and any attachments, or any part
of it is intended solely for the named addressee.  

Reading, printing, distribution, storing, commercialising
or acting on this transmission or any information it
contains, by anyone
other than the addressee, is prohibited. If you have
received this message
in error, please destroy all copies and notify 
Qld Police Credit Union Ltd on +61 7 3008 4444 or by
replying to the sender.

This message may contain legally privileged and
confidential information, and/or copyright material
of QPCU or third parties.

QPCU is not responsible for any changes made
to a document other than those made by QPCU,
or for the effect of the changes on the document's meaning.
You should only re-transmit, distribute or commercialise
the material if you are authorised to do so.

Any views expressed in this message are
those of the individual sender.  You may not rely on this
message as advice
unless subsequently confirmed by fax or letter signed by an
Officer or
Director of QPCU, or 
an Authorised Representative QPCU.

QPCU advises that this e-mail and any attached files should
be scanned to
detect viruses.  QPCU accepts no liability for loss or
damage (whether
caused by negligence or not) resulting from the use of any
attached files.

Information regarding Privacy can be found at the QPCU web
site. (
www.qpcu.org.au )

General Advice Warning

Any advice has been prepared without taking into account
your particular
objectives, financial situation or needs.  For that reason,
before acting on
the advice you should consider the appropriateness of the
advice having
regard to your own objectives, financial situation and
needs.  Where the
advice relates to the acquisition, or possible acquisition,
of a particular
financial product, you should obtain a Product Disclosure
Statement relating
to the product and consider the Product Disclosure Statement
before making
any decision about whether to acquire the product.
************************************************************
****************
*********************


-- 
Brisbane MySQL Users Group Mailing List
For list archives: http://lists.mysql
.com/ug-brisbane
To unsubscribe:
http://
lists.mysql.com/ug-brisbane?unsub=johntheneales.id.au



-- 
Brisbane MySQL Users Group Mailing List
For list archives: http://lists.mysql
.com/ug-brisbane
To unsubscribe:    http://
lists.mysql.com/ug-brisbane?unsub=bondyahoo.com