2tonejoe Posted October 23, 2008 Share Posted October 23, 2008 I have a query that extracts data from Microsoft SQL. I need to move this Data to a mysql data base. I am looking for some tips on the best way to do this. I have to do this several times a day to keep the data fresh. any directions or thoughts? Link to comment https://forums.phpfreaks.com/topic/129783-schedule-a-dump-from-sql-to-mysql/ Share on other sites More sharing options...
fenway Posted October 23, 2008 Share Posted October 23, 2008 Depends on you're able to connect to the former. Link to comment https://forums.phpfreaks.com/topic/129783-schedule-a-dump-from-sql-to-mysql/#findComment-673237 Share on other sites More sharing options...
2tonejoe Posted October 27, 2008 Author Share Posted October 27, 2008 I can connect to both. Link to comment https://forums.phpfreaks.com/topic/129783-schedule-a-dump-from-sql-to-mysql/#findComment-675722 Share on other sites More sharing options...
fenway Posted October 27, 2008 Share Posted October 27, 2008 If you can dump into CSV, then you can use that file as a DB engine directly in mysql. Link to comment https://forums.phpfreaks.com/topic/129783-schedule-a-dump-from-sql-to-mysql/#findComment-675947 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.