Extension To Odbc Import Facility To Use Mysql Table Value

[jcs]

The migration tool kit uses a where clause to allow vertical filtering. This uses fields in the odbc source to control the filter.

Could this be extended to reference a table in the destination mysql database to fetch a value to substitute in where clause

For example

say a 'where' statement like “transnum > $synctable.transnum”

In this case the value from synctable.transnum would be fetched to yield a where statement like transnum > 1234 to control migration

The alternative at present seem to be to write an external script to interrogate the mysql database and use result to update the xml for the job before running it with sja

[peterlaursen]

We had similar requests before. It would be pretty useful for 'incremental import' in situations where you cannot or won't modify the schema on the.

It it somewhat complicated to use a where criteria from one server on another and quite different one. We need a little time to consider and discuss!

[Author]

Posts