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? Quote 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. Quote 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. Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.