CODEWITHSUNDEEP
mysqlsqlsql-serverreplication
mhopkins321
mhopkins321

Reputation: 3073

Get data from SQL server 2008r2 to mysql automatically

I have a web interface (php front end, mysql backend) running in the same domain as a sql server database. I need to frequently (daily or weekly) query sql server and then load that data into mysql. What would be the most efficient way to do this?

Upvotes: 0

Views: 1824

Answers (1)

paul
paul

Reputation: 22001

you could use the SQL Server Agent to run a scheduled job that would select and export the data direct to your MySQL server.

Like this example (SQL Server Management Studio 2008 scheduled export to MS Access), but exporting to MySQL instead of MS Access

Upvotes: 1

Related Questions