Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

View MySQL tables with "Linked Servers" in SQL 2000

Status
Not open for further replies.
ariskin

ariskin

Technical User
Mar 25, 2002
2
US
I have 3 databases, two are on SQL 2000 and the third is on MySQL. I need the ability to query data from all 3 databases in an efficient manner. The SQL Server Enterprise Manager is much better than the MySQL GUI screens, so I'm trying to figure out the best way to get the MySQL tables into SQL Server.

I tried using the DTS and I constantly get error messages. Then I found something called "Linked Servers" in the Enterprise Manager. I looks like you can link to any ODBC database, but I have been unsucessful. Does anyone have any experience using the Linked Servers? How about any other work arounds?

Thanks!
 
Status
Not open for further replies.

Similar threads

E
  • Locked
  • Question
MySQL calculator tools
Replies
0
Views
222
EdZzy
E
lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
391
Chris Miller
Chris Miller
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
431
lupidol
lupidol
dylim
  • Locked
  • Question
SQL_CALC_FOUND_ROWS still runs in MySQL 8.0.29
Replies
2
Views
471
dylim
dylim
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
384
EdLentz
EdLentz

Part and Inventory Search

Sponsor

Back
Top