MS SQL to MySQL php looping code needed

I need to move 65000 rows/records from my ms sql database

and put them into my mysql database, but in 3 different tables.

So what i need is for the script to:

look at the mssql server and run a query, then go row by row through

the results.

for each result, it should look at the username and then connect to the mysql

server and check a certain table there for the same username, if it sees the same

name then it should skip and go to the new row/username in the mssql server.

If it does not find a match it should bring over the whole users row in the mssql table

to the mysql table, putting the main query data for that user in the "main" table and then

putting just the userid in the "profile" table and then putting some of the main query data

in the "personals" table.

Then it should print that username on the screen so i know where it is in the list and loop through

all of the users rows brought back from the query, 60000 out of 200,000. It should do the above for each user. Im not sure how long it will take or if you need to put some sort of delay in. id like to do it fast but efficient.

I would like this in a php page as i dont know any other easy way of doing it.

This is a script that should only be a few lines. Im not looking to spend too much.

Please reply letting me know that you understand this task and actually read it.

Thank you


Evner: PHP

Se mere: what is profile id, profile php code, match my profile, loop back, look php id, id to code, how to code php, how code, find code, what is ms sql, server code, sql, sql mysql, Sql code, skip , sean, mysql query, Mysql php, mysql mssql, mssql mysql

Om arbejdsgiveren:
( 1 bedømmelse ) Vallejo, United States

Projekt ID: #607391

Tildelt til:


I can do this work. Thanks, Suresh

$35 USD på 1 dag
(673 bedømmelser)

4 freelancere byder i gennemsnit $54 timen for dette job


Plz check PM

$30 USD in 0 dage
(38 bedømmelser)

Ready to do it

$50 USD på 1 dag
(9 bedømmelser)

Hi, Please check PM . Thanks

$100 USD in 2 dage
(0 bedømmelser)