How to move data to other database ?

[santhanalakshmi]

Hi,
I am using SQL 2000. I want to move the table data from my database to mysql database using php script?


Please help me with coding. thanks

[AutumnsDecay]

Why not just take an export backup of the database and import it into your MySQL DB?

[santhanalakshmi]

Hi,

I can't able to export in my excel also. Because its consist of lakhs of data. Please help me out

[AutumnsDecay]

No one is talking about excel. Most visual UIs for databases give you export options and formats.

Have you tried to do this on your own? Have you google'd how to export an SQL2000 database? I just did a quick google search and got a LOT of answers, most of which doing exactly what I suggested.

[santhanalakshmi]

Hi,
I am also trying an export option from SQL2000. Since, in my table contains lakhs of data, i am not unable to export it all the data from the table and i am unable to load it in MYSQL database.


Did you know PHP script? By PHP script, i wants to move data from SQL2000 to MYSQL database. Please help me out. Thanks in advance and thanks for your response.