how to export data from sql server and import to mysql automatically

[neelsbr]

hi,

i have export one table from sql server.and those data are import to mysql automatically.no manual.it runs every time gap.

please any one know how to do it..help i want to finish this work by this week

Thanks in advance

[dlite922]

You have a couple of options.

Use mysqldump (and sql server equivalent of mysqldump) and put them in a crontab / scheduled-task.

OR

Do it with code. With php, connect to the first database, get the data, connect to mysql, insert the data.

You can automate it by putting this php file in a crontab too.

Take your pick, but I suggest you go with the former if your table is pushing hundreds thousands of rows or more.

Cheers,


Dan

[neelsbr]

@neelsbr
thank u..i will try in my job..i will contact u further any reference..thank u for ur reply