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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-04 : 21:28:17
|
| Shane writes "Hi,I would like to have my "master" SQL Server replicate to a couple of MySQL servers in our webfarm. Basically, all our data would reside in the main server and all changes would be made there. For users on our sites, they would seeing dynamic pages based on the essentially read-only MySQL servers.This replication would need to occur either continually or say once per hour to ensure the data on the web is kept up to date.Why do I want to do this? Well, after just spending six figures on Software Assurance and completely blowing budgets, it has become a priority to find suitable non-MS solutions.Thanks for your help!Shane" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-05 : 07:37:05
|
From Books Online, "Replication and Heterogeneous Data Sources":quote:
Microsoft® SQL Server™ 2000 offers the ability to replicate data to any heterogeneous data source that provides a 32-bit ODBC or OLE DB driver on Microsoft Windows® 2000, Microsoft Windows NT® Server 4.0, or Windows 98 operating systems. Additionally, SQL Server 2000 can receive copies of data replicated from Microsoft Access, Microsoft Exchange, Oracle, DB2 Universal, DB2/MVS, and DB2 AS400.
Although it doesn't say MySQL specifically it at least sounds like it's possible. If you need a MySQL OLE DB provider, look here:http://ourworld.compuserve.com/homepages/Ken_North/oledbVen.htmThere might also be some other MySQL OLE DB/ODBC drivers on that page.That being said, replication may not work at all, but you can use DTS or linked servers between SQL Server and MySQL to accomplish the same kind of thing. These are documented in Books Online.You might also want to look here:http://www.sqlteam.com/Forums/topic.asp?TOPIC_ID=18458And really think about what kind of features you need to support, before you jump into MySQL. There are so many "little" things that it doesn't do that could potentially drive you insane. PostgreSQL is also freely available and has more features than MySQL. |
 |
|
|
|
|
|
|
|
SQL Server replication to MySQL