> 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
On Wed, 21 Oct 2009 16:48:21 + (GMT) Sydney Puente said:
> 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
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
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 da
