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