http://www.howtogeek.com/forum/ How-To Geek Forums Topic: Extract SQL data to MySQL en Thu, 08 Jan 2009 18:54:45 +0000 http://www.howtogeek.com/forum/topic/extract-sql-data-to-mysql#post-20928 Wed, 23 Apr 2008 22:08:10 +0000 The Geek 20928@http://www.howtogeek.com/forum/ <p>Depends... typically you'd just need them where the SQL Enterprise client is running. If you save the package to the server to run repeatedly, then you'd need the drivers on the server. </p> http://www.howtogeek.com/forum/topic/extract-sql-data-to-mysql#post-20832 Wed, 23 Apr 2008 07:34:19 +0000 pipo 20832@http://www.howtogeek.com/forum/ <p>thanks, mr geek. do i need to install the MySQL drivers to the server/PC where the SQL database is? </p> http://www.howtogeek.com/forum/topic/extract-sql-data-to-mysql#post-20831 Wed, 23 Apr 2008 07:28:04 +0000 The Geek 20831@http://www.howtogeek.com/forum/ <p>Are you talking about a SQL Server database?</p> <p>If so, just install the MySQL drivers for windows, and use the import / export feature (DTS) in SQL Server to push the data over. Simple, takes a few minutes. </p> http://www.howtogeek.com/forum/topic/extract-sql-data-to-mysql#post-20830 Wed, 23 Apr 2008 06:55:32 +0000 pipo 20830@http://www.howtogeek.com/forum/ <p>hi guys,</p> <p>i have this mini-project that i'm about to do, where i need to extract some columns and data from SQL and put it in a MySQL database. i'm not sure if there's a way to do it directly, so i was planning on using PHP to do it. the way i see it, i could use PHP to connect to the SQL database, extract the data that i want and insert it into my MySQL database.</p> <p>i was kinda hoping if there are some PHP geeks or database geeks out there who could give me some pointers or ideas. is what i'm planning feasible? </p>