Closed

Synchronize 2 mysql databases

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

Aptitudini: PHP

Vezi mai multe: synchronize table, update mysql, Synchronize, roman, php oracle mysql, Mysql, databases, check username, c++ mysql, C# MySQL, c mysql, script update database mysql, mysql select statement, php insert select, returned, php databases, mysql databases server, synchronization script, mysql users, update database mysql

Despre angajator:
( 0 recenzii ) Kitchener, Canada

ID Proiect: #2070

17 freelanceri licitează în medie 47$ pentru acest proiect

bobi2004

Hi there, I can do this for you in no time. Please check PM for details. Best regards, Bobi

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(24 recenzii)
6.1
vintcn

I can do it within 2 hours.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(8 recenzii)
4.6
nilkanth

I would complete this project within 5 working days.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(0 recenzii)
0.0
gtrimar

I can solve your problem in about 6 hours

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
rohitksharma

we have ready code use it

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(0 recenzii)
0.0
sylee

Very easy thing for me, I can write one so that it can fit with any mysql database, without knowing any structure of the your database. so that u not need to modify my code after u modify ur database structure in the f Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
hadrian

With over 5 years PHP experience, I can do this very well and very quickly. Please help me get my first review!

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(0 recenzii)
0.0
rad

We have a team of experienced programmers in PHP, you will get it done.

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
0.0
chrisranjana

Complete sync can be done between the 2 databases..master and slave...not using php though !..chris

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 5 zile
(0 recenzii)
0.0
onyx

It takes 3 hours.

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
hi5

Your description sounds more like a DROP + COPY, alternatively if the target database needs to remain online it would be simpler to do a bulk insert using a trigger to handle the collisions rather than multiple separat Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
0.0
giant3567

experience on this kind of operations.. trust me, you will get it done

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
optimumweb

OPTIMUM Web Services Agency is a professional web/software/multimedia development company located in Odessa, Ukraine. We have 5 years experience in IT outsourcing area and now we would like to increase the number of ou Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 2 zile
(0 recenzii)
0.0
surendra12

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 Mai multe

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 7 zile
(0 recenzii)
1.6
contactonline

Ready Code ... Use it ....

%bids___i_sum_sub_35%%project_currencyDetails_sign_sub_36% USD în 0 zile
(0 recenzii)
0.0
subsonmittal

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..........

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0
nosti012

sounds like an easy to develop script, but as an experienced developer i know that nothing is what it seems and i project that it will probably take one more day to twick it to your satisfaction, which is, after all, m Mai multe

%bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD în 1 zi
(0 recenzii)
0.0