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 |
|
wotrac
Yak Posting Veteran
98 Posts |
 Posted - 2005-02-07 : 13:54:00
|
| Can MySql talk to sql 2000?Are there any problems/pitfalls. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 14:09:36
|
| Yes it can. All you need is an ODBC driver to do it. You could setup a linked server inside SQL Server 2000 that points to the MySql database via an ODBC driver.Tara |
 |
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2005-02-07 : 14:30:40
|
| I take it you can then call sql 2000 stored procedures anduse DTS for transferring data between the two?Can you also create views across both? |
|
|
|
wotrac
Yak Posting Veteran
98 Posts |
Posted - 2005-02-07 : 14:31:15
|
| Can you clarify a linke server? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-07 : 14:32:37
|
| Please read up on linked servers in SQL Server Books Online (Start..All Programs..Microsoft SQL Server..Books Online)Tara |
|
|
|
Frank Kalis
Constraint Violating Yak Guru
413 Posts |
|
|
|
|
|
SQL server 2000 & MySQL