Link SQL Server tbl to mySQL Database

[RBCDS]

I have a SQL server database that contains an Employee table. Our client uses mySQL. Our client needs to link our Empoyee table to thier mySQL database.
Does anyone know how to accomplish this task?

Let me know if I'm not being descriptive enough.

Thnx, Dan

 

[sleipnir214]

I can be done, but not with any software either vendor provides.

Third-party vendors have written database bridging software to syncronize data across heterogeneous database servers.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[RBCDS]

Thanks for your post, I've been searching the web endlessly for a solution. Do you know of any reliable 3rd party vendors we should consider?

Dan

 

[sleipnir214]

Not off-hand. Sorry.

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[rzs0502]

Have you tried installing MyODBC on the MS SQL Server and creating a connection to the relevant MySQL database?

Then you could link tables from within the SQL Server database to the MySQL table.

 

[QatQat]

If your customer expects a ms Access kind of behavior from MySQL then iut can't be done. When we talk about database servers there is no linking of database or tables.


An odbc driver allows to import thedatabase but it won't keep a open link in between two different servers nor it will keep the two synchronized without an appropriate commercial software.

I wouldn't know if there is anyone worth spending money on.


Bye


Qatqat



Life is what happens when you are making other plans.

 

[RBCDS]

Thanks guys, I've been getting the same result from every source I've been searching.

Dan

 

[sleipnir214]

I pulled up all kinds of stuff with a search query of:

mysql "sql server" synchronization

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!