Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esmm1969
Starting Member
1 Post |
 Posted - 2007-08-21 : 14:24:19
|
| I humbly ask for anyone's help...I have two different databases - one in MySQL (eV12) and the other in SQL Server (Brutus). I am using DBVisualizer to perform queries. In the eV12 db, I have 3 tables to search on. In Brutus db, I have 2 tables to search on.the problem is, I was asked to compare data from one table in eV12 to Brutus database. Is there a way to search using and SQL statement techniques?I appreciate your expert opinions.Regards,Dor Marchanstudent - OCC, Michigan |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2007-08-21 : 15:17:30
|
| the easiest way would be to make a linked server from the sql server box to the mysql database. then you can integrate the tables from both systems in the same query.-ec |
 |
|
|
|
|
|
Query on SQL Server and MySQL databases