On Wednesday 21 October 2009 12:48:21 Sydney Puente wrote: > Hello, > > I have a task in hand to pull 3 tables of data from a MS SQL db and > populate a mysql 5.x db. So I plan to use perl DBI for yank the data out of > MS SQL and push it into MYSQL. I think I can handle the mysql table > creation and any tweaking that might be required to carry out the initial > dataload. > > However sync's from MS SQL to MYSQL are required every 24 hours after the > initial dataload. And this has me puzzled. > Advice anyone? > Please ;-) > > Syd
Might be worth checking out an ETL tool (Talend, Pentaho's Kettle) + cron (or the windows equivalent) to automate this. kabel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
