MSSQL to MYSQL connections

I have a windows 2003 standard server running MSSQL server 2000 standard and a remote HPUX 11i server running mysql 4.1.10 is there any way that I can schedule sql queries from the windows system to connect to the remote and retrieve data.
Is there a ODBC connector to allow connection between the databases? Budgets restraints prevent me from from using MYSQL on both systems
anamopsAsked:
Who is Participating?
 
JesterTooCommented:
You can create a "linked server" in MSSQL to run remote queries on the MySQL db.  There are two ways to effect connectivity...

1.  Install MyODBC on the MSSQL box and create a "system dsn".  
2.  Install MyOLEDB on the MSSQL box.

Here are a couple of links describing some of the processes... just google for    mssql mysql "linked server"  to find many more.

   http://www.issociate.de/board/post/25911/RE_MySQL_-%3E_Linked_Server_in_MS_SQL_Server.html
   http://www.pcquest.com/content/enterprise/2004/104040601.asp

I believe you can also use MSSQL's DTS to to create a package then schecule a job to run it unattended if desired.

HTH,
Lynn
0
 
_Marcel_Commented:
You can use ODBC to connect to mysql: use the mysql connector/ODBC:

http://dev.mysql.com/downloads/connector/odbc/3.51.html

Wheter you can use it from MSSQL to perform updates I'm not sure about, maybe it's better to ask this in the MSSQL thread(?) or maybe someone else can answer this?
0
 
crackyCommented:
More importantly, what scripting / programming language do you intend to use to get data out of the MySQL server? MySQL does indeed have an ODBC connector, but what are you using to connect to the remote and then feed back to the local?
0
Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

 
anamopsAuthor Commented:
I intend using mysql language but use the scheduling tools of MSSQL
0
 
crackyCommented:
You can't connect to your MSSQL server using your MySQL client. If you are accessing the remote MySQL server from your MSSQL local machine, you need to interface somehow with the MySQL server. You need a scripting / programming language that will interface with both servers natively or via ODBC and pull data off the MySQL server to dump into the MSSQL server. As far as I know, you can't interface with MSSQL using the MySQL client, although MSSQL might have a client that will allow you to extract data from MySQL using ODBC.
0
 
ellandrdCommented:
Budgets restraints prevent me from from using MYSQL on both systems

mysql is free, so what is stopping you?
0
 
anamopsAuthor Commented:
mysql is not free if you use in a commercial enterprise
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.