Re: mysql/sql server migration

[Johan De Meersman]

- Original Message -
 From: Adam Lanier a...@superbitbucket.com
 
 What is the recommended course of action to keep data synchronized
 between the two platforms?

Not an easy one, I think :-)

For simple one-shot copies the MySQL Connector for ODBC should do fine. I'm not 
sure if you can set up a continuous or batched replication job towards non-SQL 
server tables, it's been too long since I played with it.

I vaguely recall reading something about some tool that might do it, but I 
really don't have any idea what it was or where I saw that. Maybe someone else 
knows?


-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql

mysql/sql server migration

[Adam Lanier]

I'm involved with a project that is migrating data from sql server to 
mysql.  The project will take up to a year to complete.  During that 
period of time, we will need to synchronize data from sql server to 
mysql as we migrate windows based functionality to linux based servers.


What is the recommended course of action to keep data synchronized 
between the two platforms?




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql