Synchronize 2 mysql databases
$20-100 USD
Paid on delivery
Hi,
I would like to do the following synchronization between two database on the same server, same username/password.
Source database: z_rent_roll
Target database: users
1. When user exists in the source and targer database, but some of the user fields changed in the source database, I would like to reflect that by updating the target database.
2. When user exists in the source database but not in the target database, insert record to the target user table.
I know how to do this as a stored procedure in Oracle but not as a php code with MySQL.
here are the steps:
1. Check for source user data against target data for any updates- Select statement should return only those records that need to be updates
2. Take those returned records and update them in the target datase.
3. Check for source user data against target data for any new records
4. Insert new records into the target database.
This script will be run a as a cron every 10 minutes.
Thank you
Roman
Project ID: #2070
About the project
16 freelancers are bidding on average $44 for this job
Hi there, I can do this for you in no time. Please check PM for details. Best regards, Bobi
i am a php programmer i can do this work in one day i am new to this field but being a computer engg. i can do this..........
Hello, I have wide area experience in open source technology like php/c++/linux/so files/fusebox AND WINDOW based ASP,COM,DCOM,MTS,VB,VC++,.NET,Flash Please forward me your mail ID so i can forward you project propos More
With over 5 years PHP experience, I can do this very well and very quickly. Please help me get my first review!