Subscribe to How-To Geek

Login / Signup

Welcome to the How-To Geek Forums

We encourage you to register on our forums and post any questions you might have. The How-To Geeks monitor this forum and will respond to your question quickly.

How-To Geek Forums » Geek Stuff

Extract SQL data to MySQL

(4 posts)
  • Started 7 months ago by pipo
  • Latest reply from The Geek
  • Topic Viewed 447 times


pipo
pipo
Posts: 424

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 7 months ago #
 
thegeek
The Geek
Posts: 1610

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 7 months ago #
 
pipo
pipo
Posts: 424

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

Posted 7 months ago #
 
thegeek
The Geek
Posts: 1610

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 7 months ago #
 

RSS feed for this topic

Reply

You must log in to post.

Sponsored Links
Getting Started
About How-To Geek
What Is That Process?
svchost.exe
jusched.exe
dwm.exe
ctfmon.exe
wmpnetwk.exe 		wmpnscfg.exe
rundll32.exe
wfcrun32.exe
Ipoint.exe
Itype.exe 		Wfica32.exe
Mobsync.exe
Cmd.exe
Dpupdchk.exe Adobe_Updater.exe

Copyright © 2006-2008 HowToGeek.com. All Rights Reserved.