Terminé

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

Sean

Compétences : PHP

en voir plus : 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, MS SQL, move sql, code check, php data table, looking sql

Concernant l'employeur :
( 1 commentaire ) Vallejo, United States

Nº du projet : #607391

Décerné à:

sureshdevi

I can do this work. Thanks, Suresh

%selectedBids___i_sum_sub_4% %project_currencyDetails_sign_sub_5% USD en 1 jour
(673 Commentaires)
7.5

4 freelance font une offre moyenne de $54 pour ce travail

getndone

Plz check PM

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 0 jours
(38 Commentaires)
5.4
Identifier

Ready to do it

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(9 Commentaires)
3.8
nextgenweb

Hi, Please check PM . Thanks

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(0 Commentaires)
0.0