Linking MySQL database with other databases

[blinks]

What's the best way to set up a permanent connection between a MySQL database and another (which won't necessarily be MySQL), such that new and updated data can be transferred regularly from the MySQL database to the other. Table structure of the originating database is regularly changed, so ideally I'd want the solution to be independent of such changes. It is also possible that the originating database may at some point be moved over to PostGre, Oracle or such.

TIA

[mic2100]

i'm not 100% sure but i think u would need to use a language (like PHP, C++ etc) to pass the data between the 2 database systems. This would seem the logical thing to do since as far as i am aware mySQL doesn't have the ability to talk with other database servers.

[Old Pedant]

Easy to do with SQL Server and MySQL. Possible with Access and MySQL.

In both cases, the easiest way to do this is in the *other* database, not in MySQL.

Here are the docs for SQL Server, if you care:
http://msdn.microsoft.com/en-us/library/aa276845(SQL.80).aspx

So you could link to MySQL via the MyODBC driver.

Something quite similar--also via MyODBC--is possible with Access.