SEARCH

The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Geek Stuff

Extract SQL data to MySQL

(4 posts)
  • Started 6 years ago by pipo
  • Latest reply from The Geek
  • Topic Viewed 2560 times

pipo
pipo
Posts: 428

hi guys,

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.

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?

Posted 6 years ago
Top
 
thegeek
The Geek
Posts: 2059

Are you talking about a SQL Server database?

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.

Posted 6 years ago
Top
 
pipo
pipo
Posts: 428

thanks, mr geek. do i need to install the MySQL drivers to the server/PC where the SQL database is?

Posted 6 years ago
Top
 
thegeek
The Geek
Posts: 2059

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.

Posted 6 years ago
Top
 



Topic Closed

This topic has been closed to new replies.

Enter Your Email Here to Get Access for Free:

Go check your email!