From: Sydney Puente (sydneypuenteyahoo.com)
Date: Thu Oct 22 2009 - 04:32:13 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> 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 ;-) If there's a auto-inc key, you can find the last one from the MySQL_table then SELECT ... from MSSQL_table where key > found_key. Otherwise, add a field to the tables: seen ENUM('NEW', 'GET', 'GOT') default 'NEW'; At update time: UPDATE MSSQL_table SET seen='GET' WHERE seen='NEW'; SELECT ... FROM MSSQL_table WHERE seen='GET'; INSERT INTO MySQL_table ... UPDATE MSSQL_table SET seen='GOT' WHERE seen='GET'; lather, rinse, repeat. -- Don Read don_readstripped It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. Thanks very much Don, I think that shows the way. However I cannot make any changes to the MSSQL db. So as I only have 3 tables I am thinking of populating a 3 shadow tables in the mysql db. The network to the MSSQL db and the MSQSL db itself is unreliable, hence the need to do an extract. Any quick wins spring to mind? (Or gotchas?) Syd

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]