Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Sydney Puente (sydneypuenteyahoo.com)
Date: Thu Oct 22 2009 - 04:32:13 CDT
> However sync's from MS SQL to MYSQL are required every 24 hours after the initial
> 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?)