Linking MySQL to MS SQL

[Guggly]

Hi! I have a table in a Microsoft SQL Server database that I need to access from a MySQL database. Can I make a symbolic link between the two? I can't just import the data because it's something that gets regularly updated, but I need to work with it in MySQL.

Thanks! -- Mike

 

[BNPMike]

Just wondering what you are doing here. Presumably if you want to access SQL Server via MySQL, you are joining tables from both dbmses, and you are going to issue the SQL statement to MySQL?

I must admit I've never heard of this being done although I have used middleware which does it for you but then you are calling the middleware and not the target dbmses.

 

[bastienk]

You can use the myODBC driver and a dsn to link the dbs thru enterprise manager. Download the myODBC from mySQL.

We trasnfer databases like this frequently and it works okay. Some issues with date fields and nulls but nothing unmanagable

 

[Guggly]

BNPMike, I have my source table for a certain dataset in SQL Server. Basically it's a set of numbers and values administered outside of my control and must remain in SQL Server. A MySQL project I'm working on needs to access this data for query lookup purposes, and thus the reason I'm hoping to be able to link as an ongoing process, not just something inbetween that can use both sources (i.e. an ODBC connection in Access that would pull from both databases, etc.) But perhaps it can't be done, I'm not sure yet!

Bastienk, I have used MyODBC a bit, but that would give SQL Server access to MySQL right? What I need is something that works the other way around (unless I'm misunderstanding you), someway that MySQL can access the SQL Server data and not the reverse.

Thanks for your responses! -- Mike

 

[bastienk]

I think in this case you are gonna have to let the application handle the data retreival from MSSQL...

AFAIK mySQL does not have native support to talk to other DBs

 

[BNPMike]

bastienk

What's enterprise manager?

Guggly
If you need to do this, you could look at Information Builders EDA (now called IWAY). This will join across database managment systems. But of course it costs money.

 

[Guggly]

Enterprise Manager is the (a?) tool used to Administer SQL Server.

I'll look into IWAY, but it's probably a bit too expensive for our use. Guess I'll have to figure some other way of doing it, maybe just have some program which can access both databases via ODBC, pull the SQL Server data and update the MySQL database.

Thanks for your help guys!

 

[sleipnir214]

Although I hate to say it, if you have a constraint where some of your data must be on MSSQL, I recommend that you have your application store all of its data there.

Want the best answers? Ask the best questions!

TANSTAAFL!!